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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors