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       2499

2500       250000 (special value for 2500th for validation)

 

What Excel pivot chart shows as percentage for 2500th value is 7.41%, which is correct

I imported the excel file into Power BI and the pie chart shows 11.12%, which is *wrong*

 

It seems like there is a bug when # of series is larger than certain number.

 

Can anybody take a look and fix?

 

Thanks,

-Minsuk

Need Help

3 Replies

  • 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