Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
Hope you're all well!
I need very urgent help on one of the requirements. I'm stuck on this since quite long now.
I want to show a waterfall chart where only TOP 5 companies growth is shown & rest of the companies are capped as OTHERS.
Please allow me to explain in detail as below.
Now, Scenario I is that for some selection of the slicers I see top 5 companies + OTHERS in the waterfall chart as mentioned below:
which is acceptable.
But for Scenario II, for some other selection of the slicers, I see the below companies in the waterfall chart.
I very well understand the reason why I can see two OTHER(s) in the waterfall chart. Its becuase my dataset contains "OTHER" as one of the companies & its coming in the top 5 in terms of sales.
The requirement here is to club the two OTHER(s) into a single Other & see only the Top 5 which should be dynamic as we also have slicers.
Any help would be much much appreciated.
Thanks in advance!
Unfortunately, no couldn't find solution for this.
Hi @aditya_fractal ,
According to my understand, you want to show top5 based on slicer and remove the additional "Other" values in Waterfall visual ,right?
You could use the following formula to rank by each catetory(breakdown in waterfall visual):
rank = RANKX (
FILTER ( ALL ( 'Table' ), 'Table'[Coun] = MAX ( 'Table'[Coun]) ),
CALCULATE ( MAX ( ( 'Table'[Value]) ) ),
,
DESC
)
Then apply it to the filter pane.
From my research ,We need to set the MAXIMUM breakdown so that values will not be replaced by *Other* :
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
@v-eqin-msft Many thanks for your reply. I would like to point out a few things as below.
From what I understood from your answer is that if we remove the limit (5) from the breakdown, 'Others' which is created automatically by Waterfall chart would be removed but instead we want to combine the two 'Others' into a single company somehow.
Additionally, even if we go by applying filter on the visual using RANK measure, it would result in showing the full year sales only for the TOP 5, right?
To get into more easier understanding,
Thanks once again!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |