Forum Discussion
Pie Chart Data
First, you need to transform your data:
Go to Edit Query, Select all the columns and Go to Transform - Unpivot Columns
Change the name of columns like you want.
Close & Apply
Create a Chart
Legend-Answer
Details-Type
Values-Count of Answer
Other alternative Chart
Legend-Type
Details-Answer
Values-Count of Answer
To Sort the Answer, create a conditional column (Edit Query) :
If Answer is
Agree 1
Strongly Agree 2
Disagree 3
Strongly Disagree 4
Close & Apply
Select the column Answer in your fields panel and go to modeling Sort By Column: Thenameofyourconditionalcolumn
First, you need to transform your data:
Go to Edit Query, Select all the columns and Go to Transform - Unpivot Columns
Change the name of columns like you want.
Close & Apply
Create a Chart
Legend-Answer
Details-Type
Values-Count of Answer
Other alternative Chart
Legend-Type
Details-Answer
Values-Count of Answer
Hi Guys,
Thanks for all your help so far. I think i'm almost there.
Not sure if i am doing something wrong or missing a step, but this is the chart that I get:
Hi rcardozo,
In the Pie Chart, the different colour sectors(like the Red, Yellow, Green, Black) display there are four dategoreis in your Answer field. For each sector, there are multiple sub-sectors based on your Type field. If the result is what you want?
Best Regards,
AngeliaHi Bokazoit, Vvelardev-huizhn-msft
Thanks for all your help. I think i've figured it out.
I've now presented the data into a stacked bar graph. i just havent figured out how to change the order of the legend, but i'm pretty happy with the result.
Thanks again for everyone's help!
To Sort the Answer, create a conditional column (Edit Query) :
If Answer is
Agree 1
Strongly Agree 2
Disagree 3
Strongly Disagree 4
Close & Apply
Select the column Answer in your fields panel and go to modeling Sort By Column: Thenameofyourconditionalcolumn
Thanks so much Victor!
This works perfectly! :)
