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
This is what my Visualisation pane and my data looks like, but i'm not sure how to do this:
You need to transform the data into something like this:
Then You get this:
Thanks so much.
I'm very new to BI. How would i go about doing this? Is there a way to combine all the agrees etc in the pie graph?