Visualization HACK you wish you knew before... DYNAMIC BENCHMARK RANGE in Power BI

In this video I show you how to create a dynamic benchmark range area directly in Power BI. Enjoy the video and subscribe for more Power BI hacks!

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00 Intro
00:57 Forecast vs. Actuals Area Chart
02:00 Lower Limit and Upper Limit Measures
07:28 Formatting
12:31 Data Labels
15:45 End

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[Alan.DL]

I have no idea how do you come up with all these tricks mate, amazing!

[LeighRadmore]

This is a top idea! Would you be tempted to create a tooltip page to overide the default so you can take out the Sales - Dummy measure?

[owengrey]

This is almost exactly what I was looking for! I am currently having trouble translating this concept to create the range that would include the max and min from each month over the previous 4 year and compare the progress YTD to that range.

[PeterKontogeorgis]

time I’ve come across your channel. That was beautiful. Love the attention to detail and production quality of the video.

Very welcome addition to the other handful of quality power bi content!!!

[naylord]

Sweet baby Jesus, this is beautiful. Thank you!

[juanignacioXI]

Amazing video Bas, does ur Sales - Forecast is just the sum of a column in your data? or it is a complex measure? Thanks in advance.

[DaanDamhuis]

Interesting video! Always wanted to see how we could create this in Power BI without custom visuals.

For the Max Y values, you could also calculate it with the MAXX * 1.1 for instance, then you wouldn’t have to put it in manually

[Oivobernardo]

This solution is great! Thanks for sharing

[rauljimenez]

This is perfect for xMR graphs (process control, Nelson's rules, etc)!!

[kingingway]

Awesome tip! Simply amazing. One question though, how did you plot the Actual Sales and Forecast on the same chart without breaking the chart? Usually, the Actual stops where sales stop and Forecast continues into the future. I tried to follow along but have disjointed lines after plotting Actual and Forecast measures. Please guide me on this. No file attacked this time :(
Thank you

[Piesforallfree]

This is very helpful, thank you very much for sharing this knowledge 👍

[ashishmohan]

Hi Bas,
Again amazing real time based business problem

Very useful video and very practical need everyone for every project big thanks to share with us.



If it can possible can you plzz provide us excel data file which you used.

Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂

[rerangelt]

Jesus Bas, you realy though it. This is some trick. And very well explained. Hi from Colombia.

[fabriziocau]

Nice one, thanks! Is there any way to overwrite the tool tips though? Other than that, the chart looks great!

[sbh]

Thanks Bas! but in the latest version, Area chart does not have 'Values' field column. :( How to do this?. In my table, I have a column name high limit and low limit. I want to use it as a range

[Ayaan_khan]

I have a small query
I thought that x -axis has to be always to be a time based column but i worked on a datset in which i have to put countries in x-axis whereas years and profit on y-axis and secondary y-axis respectively . I think it depends from scenario to scenario.
please comment if i am wrong

[jeffweir]

Fantastic video. Pity that Microsoft don't fix a few simple things in their product that would make bulk-standard things like this MUCH easier, including giving us the ability to set fill to 'no fill' and fixing that stupid bug whereby markers at the top get decapitated.

[ZachRenwickData]

Good job man, creative solution for this!

[yancaue]

Great! Thanks for the video! I was wondering if there is a way to count the values out of the range, a measure to put on a card visual. If possible, could you share it with us?

[pilarbaldominos]

Sooo many great ideas in a single video!