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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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.

 

1.png

 

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.  

 

2.png

 

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.

 

1 REPLY 1
MFelix
Super User
Super User

Hi @Anonymous ,

 

Can you please share a sample information or a copy of your PBI file?

 

Using the normal visualization the result is what you get currently so all together in a single one. Believe this cvan be achieved making a similar approach I did on this post:

https://community.powerbi.com/t5/Desktop/Calculated-Column-not-working-with-measures/m-p/940435#M450591

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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