Pie Chart Data

rcardozo

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