Showing results for 
Search instead for 
Did you mean: 
neryfrederico Frequent Visitor
Frequent Visitor

Waterfall Chart – Breakdowns (Bottom 5 + Others loses + Other Gains + Top 5)

I am trying to build a waterfall chart that shows me first the bottom 5 (worsts) categories, group other loses, group gains, and than show top 5 categories. I have done that on excel.




On my dataset I have 61 itens different categories. Currently, I have hit this one (donw bellow) that it is all most what I want. I am using the default Waterfall visual. However, it makes a breakdown call “Other” that group gain and loses, which is not my desire. Also, It shows breakdown by magnitude, I have more itens that gain but it only showed one.  




I thought to create I new column based on RANK function to achieve my goals, but I do not know how to that because this table have relationship to others, so I guess it will not be dynamically once a filter per month or year. Does anyone has a tip how I could do that?

Thanks in advance.


Helpful resources

New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (961)