Bug: Pie chart not showing correct value

[gpminsuk]

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

[gpminsuk]

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]

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]

@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