I am trying to visualize the responses to a survey. I have several questions which have multiple options for the respondents to chose from.
For example Respondent one will answer question one by providing a response where you see answer1, answer2 and answer3. I would like to end up with a visualization like this.
I am fairly new to Power BI and dax measures are currently beyond me. Can anyone reccomend how to do this? or how I can learn how to do this?
I think you will have to re-structure the table.
You cannot have a 'Master' column like Question1 and under it more columns like Answer1, Answer2...AnswerN
This is what I did with the data model, then used stacked bar chart
Check if Unpivot Columns in Query Editor helps.