Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |