Power BI & DAX Tutorial: Waterfall charts with beginning and end states in 5 minutes

Can I sort that chart by breakdown?

Simply genius, for a dafty like me it took ages to grasp this. Can you please share your thought process when you came up with this? Many thanks,

This post sucks. Allthough it creates a waterfall with a begin and end value it doesn't support sorting based on specific sortorder. No matter how many people ask about it, you just don't reply to it. Even in your blogposts. Suggesting you will address it in a next video but eventually you never do. If you use months as breakdown, you always want those months sorted. If that's not possible this waterfall chart is simply useless.

You are a legend, this has saved us from purchasing a purchase third party visual. Thanks for sharing!

what is waterfall chart, what does it tells???always try to convey basics in a minute....

How I can sort the values (volume,price,mix) in defined order

Beginning date and end date I will select from slicers,and then the breakdown I wanted to see,can you please help

thanks for the video. but what if the number is negative?

Thank you for the video. You saved my day.

how do you alter the sort order? I have almost copied your set-up having a CategorySort and BreakdownSort column, however my waterfall will only order on value, not based on the CategorySort/BreakdownSort order

How many Breakdown are allow in above waterfall , I have to do 6 breakdown but while doing it in 6th breakdown it goes in other in graph area

Why multiplying it by -1?

I was able to create a similar chart, but for some reason, I get an "Other" column that I cannot remove. I am showing all the categories, so this is not related to the max. breakdowns. Any suggestions?

Hello my friend, Im having a really hard time to have this type information divided week by week using the built-in waterfall chart. So it would be a starting value, new added stuff (+ value), reassigned stuff (- value), Resolved stuff (- value) and the remaining that will be, for example, week end 06/27. The strange thing is that PowerBI is simply not "grabbing" my values as + or - even if my data source its correct. Can you help me?

Thank you for the explanation! Will be very useful. My only problem left is that I can´t sort the categories in the breakdown. I am using dates in my breakdown but they are getting out of order. Already tried sorting by column but with no sucess. If you have any idea how to solve this it would be lovely. Cheers

This is great! I was trying to have a middle category bar (So: Start, Mid, End) but having some breakdowns between Start and Mid and different breakdowns between Mid and End. Is this possible you think? I can get the 3 category bars to show but then all breakdowns are showing in both gaps.

Great video! Exactly what I needed! The only thing I still need to figure out is how to sort the variances, as someone else asked... Can't I use the breakdown ordem somehow?

Thanks for the tutorial and files. I have a question regarding sorting - I need a certain order of the buckets which is fix and does not depend on the values of the buckets (ascending/descending). In your file/tutorial it's ordered largest to smallest. When I change e.g. Volume to 20 and Gross Revenue to 100, than these 2 buckets switch. How do I make the order of the buckets fix? Thanks

How do you sort the variances? I did the same labels and it still sorts largest to smallest

Sorry, but the suggested technique did not work for me. The waterfall chart showed the value of "Volume Variance" as "Revenue Last Year" with a negative sign and the same value in the bucket "Volume Variance" with a positive sign; the other buckets and the current year total amount were zero on the chart. I replaced all calculated measures with hard-coded numbers to avoid any errors due to miscalculated measures, but the result was the same. Did Microsoft change how the waterfall chart works recently, which made this technique obsolete? I would appreciate some insight!