Forum Discussion
Waterfall components are wrong when its quantity is >200
Hi support,
I've faced the following issue with the waterfall graph:
When I build a simple waterfall graph with many breakdown components (>200) it doesn't show separate components in the correct ascending or descending order. In the example attached, Customer 3 is the major FC_2 vs FC_1 growth reason but it's not indicated on the waterfall (the same for the smallest components)
full dataset
However, when I limit the number of breakdown components to less than 200 (example file in link below) the breakdown works properly and shows correct components.
only 200 customers
How can I address the issue when I have >200 components?
Here is a link to the pbix-file: https://drive.google.com/file/d/1mCpB634hk6ipPlmXYsz6XPP7kVMATP-i/view?usp=sharing
Appreciate you help
6 Replies
v-xuding-msftCommunity Support
Hi Anonymous ,
The default waterfall chart only can show 20 breakdowns. And it will show at random. For "199 item", there aren't many customers either, like customer 2, customer 28.
If you want to show entire breakdowns, it is better to change a custom visual like Waterfall chart-xViz.
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200001336
Thank you for your reply, v-xuding-msft.
As we are prohibited from using third-party custom visuals, we are not able to use the custom waterfall chart you so kindly linked.
1. Is it possible to make the breakdown of the default waterfall chart non-random?
Many thanks in advance
- v-xuding-msft
Hi Anonymous ,
You could use Top N filter to have a try.