Forum Discussion

gpminsuk's avatar
gpminsuk
Regular Visitor
10 years ago

Bug: Pie chart not showing correct value

Hi,   I have a sample pie chart with 2500 series. The data is incremental numbers that looks simply as   Series     Count 1             1 2             2 3             3 .... 2499       249...
Need Help
gpminsuk's avatar
gpminsuk
Regular Visitor
10 years ago

Looks like 1000 is the limit for Pie chart.

And the same happens for Stacked bar chart with 60 series limit.

 

I really do not think this is the right behavior.

 

gpminsuk's avatar
gpminsuk
Regular Visitor
10 years ago

The right behavior should be

 

1. Showing everything

2. OR if there is any performance concern, show top N series* and group others as "Others" (or any other special series name)

 

*Now it's just showing top N series in raw data order, but it should show top N series ordered by Value (size of pie slice). If there is still performance concern sorting the whole data, I think that's on users hand now to optimize their data. At least, Power BI should not lie.

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    10 years ago

    gpminsuk

     

    If we turn on Legend, we can find that pie chart only show 1000 series and stacked bar chart only show 60 series as below. It seems like that it’s the chart limit. But the chart actually tells user how many series it is showing now.

     

    Best Regards,

    Herbert