Forum Discussion
Pie chart not taking correct values
Hello the community,
I am using a pie chart in Power BI to display number of items (each has an ID reference) based on category: reason but when I see the result of the visual's display it shows wrong percentage:
and without a filter it's still wrong:
it apparently divides the slices on the number of reasons and it does not a correct calculation...
did someone encountered similar issue?
Thanks in advance!
Hi kokola_san ,
Thanks for the reply from Ashish_Mathur .
I created some sample data for testing:
Type
Value
A
10
B
20
C
30
D
40
E
50
It worked fine:
I can't reproduce your problem without the pbix file. Since you mentioned that your dataset is on SharePoint, please consider creating a simple sample data that can reproduce the problem, and then provide me with the pbix file created based on this sample data. Remember not to log in to your account in Power BI Destop when uploading the pbix file.
Here are some factors that may cause problems:
- Make sure the data type of the column used for the pie chart is correct (usually numeric).
- Find the "Detail Label" area under Format and enable the Percent function.
This link may be helpful to you, because he encountered a similar problem as you, you can refer to:
Solved: Pie chart with percentage is not working - Power Platform Community (microsoft.com)
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
3 Replies
Hi,
Impossible to understand your question. Share some data to work with, explain the question and show the expected result in a simple Table format.
My database is under sharepoint, I am trying to show number of items by category.. The pie chart seems to have a bug since it's adjustinf the percentage by number of categories and not by items number for each category on total...
Hi kokola_san ,
Thanks for the reply from Ashish_Mathur .
I created some sample data for testing:
Type
Value
A
10
B
20
C
30
D
40
E
50
It worked fine:
I can't reproduce your problem without the pbix file. Since you mentioned that your dataset is on SharePoint, please consider creating a simple sample data that can reproduce the problem, and then provide me with the pbix file created based on this sample data. Remember not to log in to your account in Power BI Destop when uploading the pbix file.
Here are some factors that may cause problems:
- Make sure the data type of the column used for the pie chart is correct (usually numeric).
- Find the "Detail Label" area under Format and enable the Percent function.
This link may be helpful to you, because he encountered a similar problem as you, you can refer to:
Solved: Pie chart with percentage is not working - Power Platform Community (microsoft.com)
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
