How do I create a chart with 3 variables?

[AriSan]

Hi,

Very new to Power BI, and I really appreciate the help!

I have an Excel file of event attendees rating their experiences and I want to turn this into a chart.

Column 1 contains the event name - there are multiple events, with each attendee's response in an individual row

Columns 2-5 contain the experiences e..g "How were the presentations?", "How was the food?", etc.

The cells in each of Columns 2-5 has text that the respondent chose from a rating scale - Excellent, Good, Fair, etc.

I want to see the ratings of experiences by each event, so I've put Column 1 as a slicer on the page.

But I can't get Columns 2-5 into a single chart where I can see all the ratings for all the experiences.

I shall be grateful for any advice.

(I would prefer not to format the Excel file as it contains multiple other columns)

Thanks!!  

[VijayP]

@AriSan 

Unpivot all result columns in powerquery so you have single column to get the desired view in the Chart