Forum Discussion
How do I create a chart with 3 variables?
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!!
1 Reply
- VijayPCommunity Champion
Anonymous
Unpivot all result columns in powerquery so you have single column to get the desired view in the Chart