Forum Discussion
Multiple Response Survey question
- 9 years ago
Hello,
Faced the same thing but not for such huge amount of surveys. You could:
- go to your Queries
- duplicate the Query
- Delete all columns except IDs and 1 Question with checkboxes
- Select all collumns with answers to Checkboxes
- Go to the Transform >> Unpivot columns
- After that filter last column to disable zeros
- Delete last column
- 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.
Hello,
Faced the same thing but not for such huge amount of surveys. You could:
- go to your Queries
- duplicate the Query
- Delete all columns except IDs and 1 Question with checkboxes
- Select all collumns with answers to Checkboxes
- Go to the Transform >> Unpivot columns
- After that filter last column to disable zeros
- Delete last column
- 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.
- RaquelMergulhao1 year agoNew Member
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?