Forum Discussion
Pie chart issue
Hi All,
I have a column(column name: ABC) with 800 records. 545 records have value "1" and rest of them has "0".
I want to display them in a pie chart as a percentage like 1 has 68% values and 0 has 32% values. However when I put Column ABC in values section of a pie chart, I don't get the desired output. Is there something I am missing?
4 Replies
What are you putting in the Legend?
Try dragging the ABC column to both the legend and the values and see if that helps you any. Otherwise, please provide some more info.
With your ABC column, add one more column of your dataset, which counts the number of 1's and 0's to the pie chart. Below I have attached screenshots.
Do let me know if you have any queries.
1.
2.
3.
Also you can add ABC column to both legends and values. then change to COUNT of ABC. Shown below
1.
2.
BOTH WILL HELP YOU TO GIVE SAME RESULT
Thank you for your response.
Here is the exact scenario:
Team 1 Team 2 Toss winner Toss decision Winner abc xyz abc bat xyz xyz rst xyz bowl xyz rst xyz xyz bowl xyz abc xyz xyz bat abc xyz abc abc bowl abc abc rst rst bat rst rst xyz rst bowl xyz xyz abc abc bat xyz abc xyz abc bowl abc xyz rst xyz bowl rst rst abc abc bat rst abc rst abc bowl rst rst abc rst bowl abc abc rst rst bat rst xyz abc xyz bowl xyz rst xyz xyz bat xyz abc rst rst bat rst I need to show a pie chart with two values: team batting first won vs team bowling first won.
See attached PBIX below.
