Targets vs Actuals Chart in Power BI
Вставка
- Опубліковано 3 лип 2024
- -- LIVE Training Enrollment---
chandeep.notion.site/chandeep...
- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
- - - - Download File - - - -
www.goodly.co.in/targets-actu...
- - - - Reid Haven's Tool Tip Video - - - -
• Creating Report Toolti...
---
► Artist Attribution
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
- Source: goo.gl/fh3rEJ
Official After The Fall UA-cam Channel Below
ua-cam.com/channels/GQE.html...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: creativecommons.org/licenses - Наука та технологія
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!
Simple & effective ! Thanks for this great video !
Really nice way to show actual vs budget.
Very helpful! Well described and easy to understand. Thank you!
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!
Loved your logic Chandeep!
Thank you!
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
Really nice one Chandeep!
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. How do I get the marker value?
Marker Value =
MAX(
[Total Sales],
[Total Target]
)
How can he miss that
@@davidignatius1by chance I guess. 😅
Hi, how did you get the marker value?
Marker Value =
MAX(
[Total Sales],
[Total Target]
)
Thanks and great , would you please show the measure of the "Marker Value " Please
Marker Value =
MAX(
[Total Sales],
[Total Target]
)
@@syahmisazali6066 Thank youuu
Thankyou so much for the post and explanation👍😇
My pleasure 😊
wonderful chart
Excellent work Chandeep
Thank you!
Hi Chandeep, can u see Value 'Marker Value'. I donot understand it, thanks
thanks for sharing
In case of have negative values in Sales, how can be performed to be more elegant presented? Thanks for share your knowledge.
In the calculation, you made use of marker value. You omitted the calculation for this. Is the marker value the same as the target?
Absolutely great visual and very creatively constructed ! Thanks Chandeep.
Glad you like it!
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, 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!
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.
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.
Thanks chandeep possible have met bar unmet in percentage
Morning. How to compare excel data target (date column, target value, product column) with actual data sales in power bi?
For those looking the Market Measure is the MAX of the Total Sales or the Total Target. Opposite of the Bar Measure
What's the marker value u didn't show in the video, awesome explanation🎉🎉
u havn't explained about marker value that used in met and unmet?
Hi, I would wish to know how to change the yearly target to weekly target in power bi. Please advice. Thank you
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?
can you help a video of data preparation for this chart
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?
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 :)
Creative!
What is the measure for "marker value"?
Its in the pbix file. Its MAX(total sales,total target)
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
What is Marker Value in this?
please share all the reports you did in the videos
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
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!!! 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
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
what is marked value measure here??
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
how can i create this kind of visual with target for different parameters like revenue,profit etc... selected through a parameter
Could understand the calculations, measures
Any video to show Grand total bar with x axis month and year
👍👍👍
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
not able to access the power BI file, can someone please share in the comment box.
Could you explain the marker value
Its in the pbix file. Its MAX(total sales,total target)
How u have calculated the no of months missed what formula you have used
got an error when I making a measure "Unmet Bar" that " 'Target' is a table name and cannot be used to define a variable"
The amount of times you said "nothing but" was astonishing.
You have "nothing but" an ear for detail 😂
Thanks for pointing out.
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
Cool
Thanks!
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
@@Daniel-ip1upthank you, you save my day❤
Total target pucha tha baki sub bola Lekin o nhi batatya. bad experience .