Select-all data visualization

[pbidashboard123]

I am creating a dashboard to visualize survey response data. The issue I am running into is that I have several select-all response questions which results in answers to one single question being split into different columns. How can I combine these columns into one data visualization, preferably a bar chart, showing how many respondents selected each answer?

[v-lionel-msft · Accepted solution]

Hi @pbidashboard123 ,

Is your data like this?

How about unpivoting your columns in Power Query?

Please refer to my .pbix file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MFelix]

Hi @pbidashboard123 ,

How do you have your data setup?

Please see this post regarding How to Get Your Question Answered Quickly (courtesy of @Greg_Deckler) and How to provide sample data in the Power BI Forum (courtesy of @ImkeF).