Pie chart

[isabella2003199]

Hi everyone,

I have to plot in a graph, maybe a pie chart, some alphabetic values. I have a table like this:

Name      |      Q.1    |       Q.2    |      Q3     |

Jenny      |      N/A    |        C        |       AK     |

Rob         |      C        |        C        |      N/A    |

As possible value I have only: N/A, C, AK, NC, PC.

I would like to have a graph in which through a slicer on the name it will show the percentage of the answers. For example, selecting rob I would like to have a pie chart which shows 66% the value C and the 33% value N/A.

Thank you very much.

Isabella

[v-chuncz-msft]

@isabella2003199,

You may right click [Name] column and select Unpivot Other Columns in Query Editor, then drag [Value] to Details.

[isabella2003199]

Hi,

thankyou for your answer. However I cannot manage to achieve my desired outcome...

Isabella

[v-chuncz-msft]

@isabella2003199,

Make sure you select Unpivot Other Columns.

[isabella2003199]

Yes I have selected this element, however I don't know how to display the values..

[v-chuncz-msft · Accepted solution]

@isabella2003199,

You need to drag field to Values as well.