Waterfall Chart Limitation

[Anonymous]

Hi All,

Understand that the data point limits of a waterfall chart when both category and breakdown are present, it shows a breakdown of top 200 values.

It can be found here: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-data-points

Anyone know of a way to represent more than 200 values of data? I currently have a 365 records of data and I am required to use a waterfall chart to show the top 10 variance. However the waterfall chart only shows the top 200 values thus giving inaccurate top 10 variances due to the limitation of data set.

Amyone have a solution?

[v-yulgu-msft]

Hi @Anonymous ,

You could generate a calculated table to get Top10 rows from source dataset via TOPN. Drag fields from the new table into Waterfall chart.

Regards,

Yuliana Gu

[Anonymous]

Hi Yuliana,

Thanks for the reply! 

The issue is that the data is dynamic. The Top 10 can be derived based on a few criteria and filters, with a total of 8 different scenarios. 

With that said, it will not be possible to create a calculated table to determine the top 10 as the top 10 varies based on the filter selected.

Regards,

Kelvin

[v-yulgu-msft]

Hi @Anonymous ,

That case, I could not think of a better solution right now. Maybe you need to submit a request to increase the data point limitation to Waterfall chart.

Regards,

Yuliana Gu