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 a while. The graph is doing what I want it to I just don't know how to give each type its own bar rather than the cluster it is now. Thanks you. 

 

 

 

 

  • 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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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