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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

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
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.