Skip to main content
cancel
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

Reply
Guilherme_BI
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.

Guilherme

5 REPLIES 5
fmms
Regular Visitor

I created the idea at https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=a950946a-b7ca-ee11-92bd-000d3ad9d8ca please vote and add your comments there.

Anonymous
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.

Anonymous
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.

Rgds,

Guilherme

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.

Thanks

Helpful resources

Announcements
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.