Forum Discussion
Pie chart
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
5 Replies
- v-chuncz-msftCommunity Support
You may right click [Name] column and select Unpivot Other Columns in Query Editor, then drag [Value] to Details.
- isabella2003199Frequent Visitor
Hi,
thankyou for your answer. However I cannot manage to achieve my desired outcome...
Isabella
- v-chuncz-msftCommunity Support