Visualization to show survey ranking results

[tktmastr]

I'm wondering how to show a visualization for the following data and coming up with nothing useful! 

In a survey, we asked people to rank 6 different things in terms of importance from 1-6. Below is an example; is there a good visualization to show this, or would you reccommend maniupulating the data first in some way. Thanks!

Sizes	Colors	Price	Shipping Cost	Shipping Speed	Return Policy
1	2	3	4	5	6
6	5	4	3	2	1
6	1	5	2	4	3
4	2	3	1	6	5
3	6	1	2	4	5
1	2	3	4	5	6
6	5	4	3	2	1
5	2	6	3	1	4
6	1	5	2	4	3
4	2	3	1	6	5
3	6	1	2	4	5

[PhilipTreacy · Accepted solution]

Hi @tktmastr 

Download example PBIX file with these visuals

What I would do is add an Index column in Power Query just so you can identify each individual respondent's answers, then unpivot the columns containing the responses (scores) to give this (this isn't the entire table)

You can then use a radar chart (from Microsoft) Radar Chart (microsoft.com) to plot the average (or max, whatever you are interested in) of these responses for each attribute (Category).  You could even plot the Avg, Max and Min all together.  This plot just shows Avg.

You could plot the same data using a Clustered Column (see Page2 of my file for this)

If you want to induce a headache you could add the Respondents to the Legend - you will need sunglasses to look at the default colors.  You could manually change each color so they are easier on the eye but that'll be a lot of work if you have a lot of responses.

Regards

Phil

[tktmastr]

I think the radar chart is very helpful in my case. Thank you!