Pie chart issue

[shikhar6339]

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?

[shikhar6339]

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.

[KNP]

See attached PBIX below.

[Anonymous]

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

[KNP]

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.