Forum Discussion
Piechart wrong percentage
Using 2 tables, 1 for "customer code" and another with "invoice Number", 2 different visualisations showing different percentage.
Why???
1.- How can I fix it?
2.- and when we will be able to use count as a slicer??
ntalam , got it. Pie visual has a limit on the maximum number of rows it can have. In your first post, you can see an "i" sign. Hover over that. You can see a message that there more than 3500 points. In a few visuals like scatter you have the option to change it, but I do not think you can do that in the pie.
So, reduce the number of data points in the pie.
For excat limits refer: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-data-points
3 Replies
ntalam , The first one seems to be correct. What you have to use for both for % of total. Is there a filter on pie visual ?
Difficult to say why the second one is wrong unless we look at the data.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
As soon I use lower numbers, it gets right.
Both have the same datasource.
The slicer is just reducing the amount of invoices group by count distinct
ntalam , got it. Pie visual has a limit on the maximum number of rows it can have. In your first post, you can see an "i" sign. Hover over that. You can see a message that there more than 3500 points. In a few visuals like scatter you have the option to change it, but I do not think you can do that in the pie.
So, reduce the number of data points in the pie.
For excat limits refer: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-data-points
