Modeling a question with several answer options in a 100% stacked bar chart

[Anonymous]

Hi all, 

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?

[Anonymous]

This is where im out with my data source on top and where im at with the visualization on the bottom. 

[v-chuncz-msft]

@Anonymous ,

Check if Unpivot Columns in Query Editor helps.

https://community.powerbi.com/t5/Desktop/matrix-to-table-help/td-p/329415

[Anonymous]

It seems like it does make things diffirent but I don't know enough for that to help me. 

[Anonymous]

Hey,

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