Clustered Bar Chart Help

[Anonymous]

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 · Accepted solution]

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