Forum Discussion

Tijevancasteren's avatar
Tijevancasteren
Regular Visitor
9 years ago
Solved

Multiple Response Survey question

Hello all,

I'm currently stuck on a project and I hope you guys could help me solve my problem. I have a database with 700 surveys, including some multiple response columns. My survey questions were Matrix-like questions.  Each statement has around 6 possible boxes to be ticked. This means I have a lot of columns with 1's and 0's, for each possible answer.  I want to group these answers somehow, and visualize them. Does anyone how to tackle these multiple response answers?

  • Barmaleikin's avatar
    Barmaleikin
    9 years ago

    Hello,

     

    Faced the same thing but not for such huge amount of surveys. You could:

    1. go to your Queries
    2. duplicate the Query
    3. Delete all columns except IDs and 1 Question with checkboxes
    4. Select all collumns with answers to Checkboxes
    5. Go to the Transform >> Unpivot columns
    6. After that filter last column to disable zeros
    7. Delete last column
    8. Close & Load

    You will get a table with ID and Column, lets name it "Selected Checkboxes" 

    Throw IDs and Relationship type "1 to many", plus "filter in both directions", you could use slicers/demographic data from the main table vs Checkboxes answers.

     

    P.S. Doing in this way also gives you an opportunity to use Checkbox question as Slicer to the main table data.

2 Replies

  • Barmaleikin's avatar
    Barmaleikin
    Advocate I
    9 years ago

    Hello,

     

    Faced the same thing but not for such huge amount of surveys. You could:

    1. go to your Queries
    2. duplicate the Query
    3. Delete all columns except IDs and 1 Question with checkboxes
    4. Select all collumns with answers to Checkboxes
    5. Go to the Transform >> Unpivot columns
    6. After that filter last column to disable zeros
    7. Delete last column
    8. Close & Load

    You will get a table with ID and Column, lets name it "Selected Checkboxes" 

    Throw IDs and Relationship type "1 to many", plus "filter in both directions", you could use slicers/demographic data from the main table vs Checkboxes answers.

     

    P.S. Doing in this way also gives you an opportunity to use Checkbox question as Slicer to the main table data.

    • RaquelMergulhao's avatar
      RaquelMergulhao
      New Member
      1 year ago

      Hello!!!

      I'm very, very new at Power BI.

      I'm working in a dashboard to show results of opinion surveys.

      My database has 76.000 records, and I have one multiple answer question which has 22 categories, one per column..  

      I don't know how to tabulate and chart this...

      Could you please help me?