Simplicity, Complexity, "out of the box" thinking, all rolled into one! Thank you for an incredibly helpful example of how to think about using PowerBI! Yikes, if someone gave me the visual and said recreate, I'd be working on it for the next month or two full time, and still not have it done!
Thanks, it was very useful. But I have a scenario where I have actuals till certain months and forecast hours for the entire year, but I wanted to subtract overall budget from actuals month by month and show that in a trend chart using a single measure. I actually created multiple measures to achieve this. It could be helpful, if you could post a video for this scenario.
Hi Chandeep, Amazing stuff, Could you also like make a chart. for Actual Sales vs Target vs LY sales in powerbi. Comparison bar with Percentages +/- . Badly need to learn those. And if you could explain the Dax part it would be great.
Hi, I loved your presentation! (please note that my son uses my account, there go the the name) I would like to attempt the same visual for my data, however I am not sure if I can get that to work... I am fairly new at learning powerBi, and am learning as I go, with a lot of help from partners. Here is what I am working with, I have requests received date vs dates completed and would like get an amount showing how many attained target of 3 days to complete and how many did not.....
Thank you very much. However, I cannot see the value of the Met Bar. I have used the Power BI file download to create it. However, Nothing is been seen on the met bar above the target.
Trying to work out a stock target for a group of shops My formula for Target, SUM('TargetTable'[Targetstock]) Is adding all of the stock targets together It's a separate table with 2 columns, one for the shop I.D, and one for their target stock level I've replaced the X axis with the shop I.D What could be the issue? what should my Dax formula be for finding the shop specific target stock level?
Would you be able to expand on this with the use of field parameters to enable dynamic selection? Can’t get it working and I’m not sure if it’s possible…
By all the arguments on the comments I've written below, could you help me doing 2 curves (graphic lines)? Since first line is the TARGET (=FORECAST) data. And, the second graphic (chart) line is half of ACTUAL (by today) and half of REPLANNED (after today, automatically). It begins with ACTUAL (from beggining date until today, automatically) and the same line continues with REPLANNED data, I mean, all the future action/activities one didn't achieved, but has proposed a new date, calde REPLANNED, as a new chance to achieve a goal. Was I clear in my comments? Thank you in advance.
Hi, Chandeep! Congratulations on your videos; always nice tips, and very helpful! I'm from Brazil, and I like to learn with your chalanges in Power BI! That video about "Running total for Dates and Non Dates values" was awesome!!! Well, I've been trying to make a S Curve Chart in Power BI by using ACTUAL vs TARGET (forecast, baseline) vs REPLANED (for what one have not achieved) data. I have used some DAX formulas to make the line (CHART, graphic,) of replanned, but I have difficults in making that automatically in DAX. Could you help me with this? Or maybe making a video teaching how to create a chart like this in Power BI? If you like, I can send you an Excel database to illustrate what I mean. Thank you in advance!
Hi I have a situation where monthly plan values to should change based on previous months actual, note the total plan for the year should be constant hence based on total actual till last date the Plan or forecast for remaining months should be derived based on logic where equal values will be allocated in remaining months (Total remaining forecasts divided by total remaining months)…Pls help
Help needed on this. I want to plot the area chart from a coloum with different colours based on some conditions like if the value is going above 155 it will show the area in blue and below 20 it will show the area in Red. But when I am applying conditional formatting on y axis values, the option is only changing the y axis legend value's colur not the colour of area chart. Kindly help on this. Thanks in advance
Great Tutorial: I just cant get the two X-Axis to allign. My "Target" is hovering slightly above the Barchart even though the same value. Any Idea? thx
Hi, great video!!! One question though, I would like to recreate exactly this concept but in a "Line and stacked ROW chart". Does that exist? The fact is that it would look better to do the chart in rows instead of columns
@@michaelt312 Creators should accept bad sentiment and use it as feedback, the same way they accept good setntiment. You my friend can stop commenting on my tone and get a life
@@dinohadjiyannis3225 , just because you learned nothing and you consider that to be helpful shows your arrogance and your ignorance. Not all videos are created for you and your needs. And I promise, we would never be friends.
Download Power BI File here - www.goodly.co.in/wp-content/uploads/2021/08/Target-Charts.zip
thank u so much
Thank you :D!!!
Do you have standard formula to get the monthly target??
Really appreciate you!
Simplicity, Complexity, "out of the box" thinking, all rolled into one! Thank you for an incredibly helpful example of how to think about using PowerBI! Yikes, if someone gave me the visual and said recreate, I'd be working on it for the next month or two full time, and still not have it done!
Glad it was helpful!
Hi, how did you get the marker value?
Marker Value =
MAX(
[Total Sales],
[Total Target]
)
Hi. How do I get the marker value?
Marker Value =
MAX(
[Total Sales],
[Total Target]
)
How can he miss that
@@davidignatius1by chance I guess. 😅
Thanks and great , would you please show the measure of the "Marker Value " Please
Marker Value =
MAX(
[Total Sales],
[Total Target]
)
@@syahmisazali6066 Thank youuu
For those looking the Market Measure is the MAX of the Total Sales or the Total Target. Opposite of the Bar Measure
Really nice way to show actual vs budget.
Your way of presentation bagged me so many compliments at workplace you have no idea. Thank you so much. Implementing this in my new work place also
Keep at it, Swiya. More to come :)
Wish you the best
In the calculation, you made use of marker value. You omitted the calculation for this. Is the marker value the same as the target?
This is very helpful. Been searching for this tutorial since stone age 😂 and finally found at last😅 Thank you!
What is the measure for "marker value"?
Its in the pbix file. Its MAX(total sales,total target)
Hi Chandeep, can u see Value 'Marker Value'. I donot understand it, thanks
Thanks, it was very useful. But I have a scenario where I have actuals till certain months and forecast hours for the entire year, but I wanted to subtract overall budget from actuals month by month and show that in a trend chart using a single measure. I actually created multiple measures to achieve this. It could be helpful, if you could post a video for this scenario.
Very helpful! Well described and easy to understand. Thank you!
Simple & effective ! Thanks for this great video !
Sir you are explaining very nicely. Could you please make all power bi video in Hindi for wide range of learner
www.youtube.com/@desigoodly
In case of have negative values in Sales, how can be performed to be more elegant presented? Thanks for share your knowledge.
Loved your logic Chandeep!
Thank you!
Thank you so much for such a neat trick.
Can we make similar chart horizontally
DO YOU MANAGE TO DO IT? IF YES PLEASE CAN YOU SHERE THE SOLUTION?
What's the marker value u didn't show in the video, awesome explanation🎉🎉
Hi Chandeep. Awesome visual and tutorial! Thanks for sharing how to do this and all the associated resources and links you included! Thumbs up!!
Glad it was helpful!
u havn't explained about marker value that used in met and unmet?
Excellent work Chandeep
Thank you!
Hi Chandeep, Amazing stuff, Could you also like make a chart. for Actual Sales vs Target vs LY sales in powerbi. Comparison bar with Percentages +/- . Badly need to learn those. And if you could explain the Dax part it would be great.
What is Marker Value in this?
Hi, I loved your presentation! (please note that my son uses my account, there go the the name)
I would like to attempt the same visual for my data, however I am not sure if I can get that to work... I am fairly new at learning powerBi, and am learning as I go, with a lot of help from partners. Here is what I am working with, I have requests received date vs dates completed and would like get an amount showing how many attained target of 3 days to complete and how many did not.....
Thank you very much. However, I cannot see the value of the Met Bar. I have used the Power BI file download to create it. However, Nothing is been seen on the met bar above the target.
Thanks chandeep possible have met bar unmet in percentage
Trying to work out a stock target for a group of shops
My formula for Target,
SUM('TargetTable'[Targetstock])
Is adding all of the stock targets together
It's a separate table with 2 columns, one for the shop I.D, and one for their target stock level
I've replaced the X axis with the shop I.D
What could be the issue? what should my Dax formula be for finding the shop specific target stock level?
Would you be able to expand on this with the use of field parameters to enable dynamic selection? Can’t get it working and I’m not sure if it’s possible…
Thankyou so much for the post and explanation👍😇
My pleasure 😊
Really nice one Chandeep!
Hi, I would wish to know how to change the yearly target to weekly target in power bi. Please advice. Thank you
Absolutely great visual and very creatively constructed ! Thanks Chandeep.
Glad you like it!
Hi Chandeep, can you please let me know what formula have you put in market value which you have used in both met & unmet?
Marker Value =
MAX(
[Total Sales],
[Total Target]
)
Hi Great video!!
Just a question from my side: Can we have this chart vertically instead of horizontally?
Thankyou
I think that should not be a problem!
@@GoodlyChandeep HOW???? please shere solution
Can you do this with a vertical bar chart?
By all the arguments on the comments I've written below, could you help me doing 2 curves (graphic lines)? Since first line is the TARGET (=FORECAST) data. And, the second graphic (chart) line is half of ACTUAL (by today) and half of REPLANNED (after today, automatically). It begins with ACTUAL (from beggining date until today, automatically) and the same line continues with REPLANNED data, I mean, all the future action/activities one didn't achieved, but has proposed a new date, calde REPLANNED, as a new chance to achieve a goal. Was I clear in my comments? Thank you in advance.
wonderful chart
Hi, Chandeep! Congratulations on your videos; always nice tips, and very helpful! I'm from Brazil, and I like to learn with your chalanges in Power BI! That video about "Running total for Dates and Non Dates values" was awesome!!! Well, I've been trying to make a S Curve Chart in Power BI by using ACTUAL vs TARGET (forecast, baseline) vs REPLANED (for what one have not achieved) data. I have used some DAX formulas to make the line (CHART, graphic,) of replanned, but I have difficults in making that automatically in DAX. Could you help me with this? Or maybe making a video teaching how to create a chart like this in Power BI? If you like, I can send you an Excel database to illustrate what I mean. Thank you in advance!
Could you explain the marker value
Its in the pbix file. Its MAX(total sales,total target)
Hi I have a situation where monthly plan values to should change based on previous months actual, note the total plan for the year should be constant hence based on total actual till last date the Plan or forecast for remaining months should be derived based on logic where equal values will be allocated in remaining months (Total remaining forecasts divided by total remaining months)…Pls help
Help needed on this. I want to plot the area chart from a coloum with different colours based on some conditions like if the value is going above 155 it will show the area in blue and below 20 it will show the area in Red. But when I am applying conditional formatting on y axis values, the option is only changing the y axis legend value's colur not the colour of area chart. Kindly help on this. Thanks in advance
can you help a video of data preparation for this chart
Great Tutorial:
I just cant get the two X-Axis to allign. My "Target" is hovering slightly above the Barchart even though the same value.
Any Idea? thx
Hi, great video!!! One question though, I would like to recreate exactly this concept but in a "Line and stacked ROW chart". Does that exist? The fact is that it would look better to do the chart in rows instead of columns
same question
Morning. How to compare excel data target (date column, target value, product column) with actual data sales in power bi?
The amount of times you said "nothing but" was astonishing.
You have "nothing but" an ear for detail 😂
Thanks for pointing out.
Great content ! can you please provide the link to the video by Reid Havens you mentioned ?
Just added it to the video description.. Thanks for pointing it out :)
what is marked value measure here??
Could understand the calculations, measures
how can i create this kind of visual with target for different parameters like revenue,profit etc... selected through a parameter
Bar =
VAR _Actual = [Total Sales]
VAR _Target = [Total Target]
VAR _Bar =
MIN(
_Actual,
_Target
)
RETURN _Bar
Marker Value =
VAR _Actual = [Total Sales]
VAR _Target = [Total Target]
VAR _MarkerValue =
MAX(
_Actual,
_Target
)
RETURN _MarkerValue
Target Met Bar =
VAR _Actual = [Total Sales]
VAR _Target = [Total Target]
VAR _Delta =
IF(
_Actual >= _Target,
[Marker Value] - [Bar]
)
RETURN _Delta
Target Unmet Bar =
VAR _Actual = [Total Sales]
VAR _Target = [Total Target]
VAR _Delta =
IF(
_Actual < _Target,
[Marker Value] - [Bar]
)
RETURN _Delta
thanks for sharing
Any video to show Grand total bar with x axis month and year
please share all the reports you did in the videos
What is market value in this video?
Creative!
How u have calculated the no of months missed what formula you have used
Is it possible to make this a bar chart?
I am suspecting a stacked bar chart could be possible. It will follow the same logic
not able to access the power BI file, can someone please share in the comment box.
got an error when I making a measure "Unmet Bar" that " 'Target' is a table name and cannot be used to define a variable"
what is marker value? target value?
You can see it in the example file posted by Chandeep:
Marker Value =
MAX(
[Total Sales],
[Total Target]
)
@@Daniel-ip1up THANK YOU, the file is not available and I was going crazy
Cool
Thanks!
👍👍👍
Total target pucha tha baki sub bola Lekin o nhi batatya. bad experience .
i learned nothing.
You should have said nothing. Not all videos are created just for you.
@@michaelt312 this is the whole point of a comment section - To actually say something.
@@dinohadjiyannis3225, how about a tone that isn't condescending then.
@@michaelt312 Creators should accept bad sentiment and use it as feedback, the same way they accept good setntiment. You my friend can stop commenting on my tone and get a life
@@dinohadjiyannis3225 , just because you learned nothing and you consider that to be helpful shows your arrogance and your ignorance. Not all videos are created for you and your needs. And I promise, we would never be friends.