Forum Discussion

sd_09's avatar
sd_09
Frequent Visitor
2 years ago
Solved

Clustered Bar chart

Hi all,    I am trying to make a clustered bar chart in PowerBI, similar to one that I made in excel, but cant. I have sample data below.    In the chart, I would like to provide the averages of ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    sd_09  thanks

     

    He're is a short video that demonstrates how to do the visual you want with the sample of data you provided, tell me if its good for you

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi sd_09 

 

I don't know if I figured out your need but here is a solution:

With the data you provided:

  • I went to PowerQuery
  • I selected the Q1 score, Q2 score and Q3 score columns
  • Right click > "Unpivot only selected columns" 
  • I got "Attribute" and "Value" columns

Now within PowerBI

  • Stacked column chart

 

OR to be more precise "provide the averages of each of these questions split by survey type"

 


Does it answer your question?

 

sd_09's avatar
sd_09
Frequent Visitor
2 years ago

Hey Anonymous 

 

Thanks for your response! Unfortunately, when I try to unpivot these columns, it gives me all the columns with error in the data set. Not sure why this is the case? Could it be because of blanks?