Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

  • VijayP's avatar
    VijayP
    Community Champion

    Anonymous 

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