Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
AriSan
Regular Visitor

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 1
VijayP
Super User
Super User

@AriSan 

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




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.