Targets vs Actuals Chart in Power BI

Подписаться 89 тыс.

Просмотров 96 тыс.

50% 1

-- 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 RU-vid Channel Below
ru-vid.com/show-UCGQE...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: creativecommons.org/licenses

Наука

Опубликовано:

3 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 93

@GoodlyChandeep 2 года назад

Download Power BI File here - www.goodly.co.in/wp-content/uploads/2021/08/Target-Charts.zip

@ThaiNguyen-ly2vn 2 года назад

thank u so much

@m.yasmincarrillo5851 2 года назад

Thank you :D!!!

@NeLzKieTV Год назад

Do you have standard formula to get the monthly target??

@aalyasb4050 3 месяца назад

Really appreciate you!

@tonyc945 2 года назад

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!

@GoodlyChandeep 2 года назад

Glad it was helpful!

@pondyanand 2 года назад

Simple & effective ! Thanks for this great video !

@PeterKontogeorgis 2 года назад

Really nice way to show actual vs budget.

@kenjulieking9251 Год назад

Very helpful! Well described and easy to understand. Thank you!

@wayneedmondson1065 2 года назад

Hi Chandeep. Awesome visual and tutorial! Thanks for sharing how to do this and all the associated resources and links you included! Thumbs up!!

@GoodlyChandeep 2 года назад

Glad it was helpful!

@mirr6007or Год назад

Loved your logic Chandeep!

@GoodlyChandeep Год назад

Thank you!

@swiyadesarkar6958 Год назад

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

@GoodlyChandeep Год назад

Keep at it, Swiya. More to come :) Wish you the best

@juanignacioXI 2 года назад

Really nice one Chandeep!

@learnforfree493 2 года назад

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.

@dinaligunawardena4098 2 года назад

Hi. How do I get the marker value?

@agnaldofondo4013 Год назад

Marker Value = MAX( [Total Sales], [Total Target] )

@davidignatius1 Год назад

How can he miss that

@chaule1614 Год назад

@@davidignatius1by chance I guess. 😅

@anulikaazubike2591 Год назад

Hi, how did you get the marker value?

@Karol-uu4hm 3 месяца назад

Marker Value = MAX( [Total Sales], [Total Target] )

@digdin12345 2 года назад

Thanks and great , would you please show the measure of the "Marker Value " Please

@syahmisazali6066 2 года назад

Marker Value = MAX( [Total Sales], [Total Target] )

@ingridgwladys2827 Год назад

@@syahmisazali6066 Thank youuu

@nusratshaikh3368 Год назад

Thankyou so much for the post and explanation👍😇

@GoodlyChandeep Год назад

My pleasure 😊

@hatranthithanh2516 2 года назад

wonderful chart

@TalhaShakeelpak Год назад

Excellent work Chandeep

@GoodlyChandeep Год назад

Thank you!

@ThaiNguyen-ly2vn 2 года назад

Hi Chandeep, can u see Value 'Marker Value'. I donot understand it, thanks

@FRANKWHITE1996 2 года назад

thanks for sharing

@RogerSlides 2 года назад

In case of have negative values in Sales, how can be performed to be more elegant presented? Thanks for share your knowledge.

@sia_ibk Год назад

In the calculation, you made use of marker value. You omitted the calculation for this. Is the marker value the same as the target?

@walteradamsbe Год назад

Absolutely great visual and very creatively constructed ! Thanks Chandeep.

@GoodlyChandeep Год назад

Glad you like it!

@9840708603 2 года назад

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.

@wildecorrea6477 2 года назад

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!

@derrickkuria4206 2 года назад

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.

@richardostrea7842 2 года назад

Can you do this with a vertical bar chart?

@wildecorrea6477 2 года назад

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.

@bakoubak5489 10 месяцев назад

Thanks chandeep possible have met bar unmet in percentage

@alibaroroh9355 2 года назад

Morning. How to compare excel data target (date column, target value, product column) with actual data sales in power bi?

@blakemiller8084 5 месяцев назад

For those looking the Market Measure is the MAX of the Total Sales or the Total Target. Opposite of the Bar Measure

@MoonShine-bs6cl 8 месяцев назад

What's the marker value u didn't show in the video, awesome explanation🎉🎉

@shubhampatel3582 2 года назад

u havn't explained about marker value that used in met and unmet?

@peterwenje2565 5 месяцев назад

Hi, I would wish to know how to change the yearly target to weekly target in power bi. Please advice. Thank you

@dashathomas9395 Год назад

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?

@hatranthithanh2516 2 года назад

can you help a video of data preparation for this chart

@nishantkumar9570 Год назад

Thank you so much for such a neat trick. Can we make similar chart horizontally

@user-rk6br2gp5o Год назад

DO YOU MANAGE TO DO IT? IF YES PLEASE CAN YOU SHERE THE SOLUTION?

@pk5134 2 года назад

Great content ! can you please provide the link to the video by Reid Havens you mentioned ?

@GoodlyChandeep 2 года назад

Just added it to the video description.. Thanks for pointing it out :)

@tayfuny3441 2 года назад

Creative!

@tsalsabillawinny8239 2 года назад

What is the measure for "marker value"?

@email2niranjan 2 года назад

Its in the pbix file. Its MAX(total sales,total target)

@subeenmathur7182 11 месяцев назад

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

@prachikanoongo1221 10 месяцев назад

What is Marker Value in this?

@puppalanarender7430 2 года назад

please share all the reports you did in the videos

@banibhushansingh9437 7 месяцев назад

Sir you are explaining very nicely. Could you please make all power bi video in Hindi for wide range of learner

@GoodlyChandeep 7 месяцев назад

www.youtube.com/@desigoodly

@aartitripathi2544 2 года назад

Hi Chandeep, can you please let me know what formula have you put in market value which you have used in both met & unmet?

@agnaldofondo4013 Год назад

Marker Value = MAX( [Total Sales], [Total Target] )

@Jober038 Год назад

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

@fabriziorecalde 10 месяцев назад

same question

@SerendipitySunday 3 месяца назад

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

@omkar180 10 месяцев назад

what is marked value measure here??

@jasmin8486 Год назад

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