Forum Discussion
Waterfall components are wrong when its quantity is >200
Community SupportHi 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.
- v-xuding-msft
Hi Anonymous ,
Does TopN filter work for you?
Hi v-xuding-msft,
I appreciate you taking the time.
We have tried different filtering approaches (i.e. not only the Top N filtering you so kindly suggested).
Regrettably, we do not find filtering to be a satisfactory solution, as it changes the totals.
We would like to keep all the numbers the same while having better control over which components (customers in this case) are displayed in the chart.
Many thanks for taking the time