Create a chart from the Sum of columns

[wonderful]

Have the table above and i would like to know how i can add up the sum of the "YES" and create a pie chart without the need of doing them separately.

for example

Pineaple =  3 yes

mango = 4 yes

orange = 2 yes

guava = 5 yes

peach = 6 yes

and draw a pie chart from that

[v-juanli-msft · Accepted solution]

Hi @wonderful

From your screenshot, the sum of the "YES" for each column should be 

To get this table, you need go to "Home"->"Edit Queries", then "Transform"->"Unpivot columns"->"Only selected ones"

Then "close &&apply", create a measure

Measure = CALCULATE(COUNT(Sheet1[Value]),FILTER(ALLEXCEPT(Sheet1,Sheet1[Attribute]),[Value]="Y"))

Best Regards

Maggie

[wonderful]

Hie @v-juanli-msft

I tried it and it is working perfectly, You are a life saver 🙂 Thank you for your help, I appreciate big timre.

Kindly Regards,

Wonderful