cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wonderful Frequent Visitor
Frequent Visitor

Create a chart from the Sum of columns

Analys.PNG

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Create a chart from the Sum of columns

Hi @wonderful

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

2.png

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

3.png

Then "close &&apply", create a measure

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

1.png

 

Best Regards

Maggie

2 REPLIES 2
Community Support Team
Community Support Team

Re: Create a chart from the Sum of columns

Hi @wonderful

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

2.png

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

3.png

Then "close &&apply", create a measure

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

1.png

 

Best Regards

Maggie

wonderful Frequent Visitor
Frequent Visitor

Re: Create a chart from the Sum of columns

Hie @v-juanli-msft

 

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

 

Kindly Regards,

 

Wonderful