Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Waterfall Chart Limitation

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?

 

Need Help

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        v-yulgu-msft
        Microsoft Employee
        7 years ago

        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