Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

Waterfall Chart - Sorting by Breakdown

Dear All,


I've been looking for a solution to sort my Waterfall chart by breakdown instead of size. The idea is to give to management clear view on the variations between diferent periods, but the order for those KPIs should not change for comparison reasons.


I went thru many topics open in the Community, however I did not find any solution for this. I am currently using version 2.70.5494.761 (June 2019).


Please find below an example.

Waterfall example.png


Thank you in advance.


Regular Visitor

I created the idea at please vote and add your comments there.

Not applicable

Thanks for sharing this! I am looking for the same feature. I don't understand why Microsoft sometimes skips to add a feature like this one, when it would be so easy for them to sort breakdown like all the other sorting options.

Not applicable

Hello MilkTea, thanks for the link but it is not what I am looking for. In my case I cannot sort columns because I have repeated indicators which will not work even applying index.


Well, I dont think Waterfall chart has this option. So the solution is to create a stacked column chart using ups and downs formula.


Thank you.



Hi @Guilherme_BI 

I had similar situation. Please can you let me know how you created a stacked column chart using ups and downs formula? I look forward to hearing from you.


Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.