Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Survey data - converting multiple columns in one table to categories, averages etc to chart

Hello

 

I am working with survey data and have asked the same three questions for a number of products. The exported survey results have a single column for each result which is making it difficult to chart or link tables together. I have been watching videos on calculating tables and linking tables but not getting far. 

 

When the information comes into POwer BI there is a single table with 9 columns with labels such as Product 1: Benefit, Product 1: Use, Product 1: Frequency, Product 2 Benefit etc. There is a numerical response which I have been able to make a List Measure of but don't know what to do next. 

 

 

The end result is ideally a Spider chart with Benefit, Use Freq as the axis and the average responses over the top.

 

I feel like I am missing a simple step to get some tables, categories, and calculations all happening. 

 

Any assistance greatly appreciated.

N

 

 

Desired end result

 

  • Hi,

     

    The "Unpivot other columns" feature should work.  To get specific help, share a dataset in a format that can be pasted in MS Excel.

7 Replies

  • Hi,

     

    The "Unpivot other columns" feature should work.  To get specific help, share a dataset in a format that can be pasted in MS Excel.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks so much! Worked perfectly. 

      I then split columns further to get the product category and question.