Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Clustered Bar Chart Help

Hi Power BI community, I am trying to make a bar chart for the average rank of these training types but I can't find a way to uncluster the data. I am new to Power BI and have been stuck on this for...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous,

    According to your snapshot, I'd like to suggest you do 'unpivot columns' on your value fields to convert them as 'attribute' and 'value'. Then you can create 'Clustered Bar chart' with category filed as axis, attribute a legend, value as value fields to achieve your requirement.

    Unpivot columns (Power Query) 

    Regards,

    Xiaoxin Sheng