Previously, I talked about what a pain in the neck waterfall charts are in Power BI. I also recorded a video about it here.
However, the video can be hard to follow, therefore, I have now recorded a tutorial. You can download the desktop file with all the calculations here:
10 thoughts on “Power BI & DAX Tutorial: Waterfall charts with beginning and end states in 5 minutes”
Hello I tried to do what you explained in the video, following the link but unfortunately the value of the scomposition goes on “blank” and not on the label of the scomposition… may you help me? If necessary, I can attach also the pbi example. Thank you!
you may want to try Simple Waterfall chart custom visual. I did a video on it as well; it’s much simple to get to work then the regular waterfall chart in Power BI: https://www.youtube.com/watch?v=–C7V_FwKEM
I have the same problem. Did you find a fix?
Thank you for your very interesting work.
How can we make this graph dynamic and change the years Revenue last year and Revenue this year ?
Any possibility to sort the pillars not by value but by the sort order in the tables or a different column? I can’t get that part to work 😦 BR, Linus
yes, i will be addressing this shortly in another video
Thank you 🙏, Looking Forward 🙂
I have the same issue like Linus. I need to have a specific order for the breakdowns and I have no idea how to do this. Would be great if you could explain how this works.
Thank you 🙂
Any news about the sorting dilemma?
Firstly, thanks for this great video! I am also hoping to sort the pillars by the sort order in the tables – do you have a blog post about this? Thank you!