I'm struggling to figure out why all the bars are grouped together and I can't get them to show the labels underneath each bar. Any help would be much appreciated!
I'm trying to get this...
To look more like this...
My data looks like this...
HI @riegersn
You need to adjust your data model as below:
https://radacad.com/pivot-and-unpivot-with-power-bi
In edit queries, Selected S1,S2,S3,...S9. then unpivot them.
For example:
Now create a bar chart, drag [Attribute] to x-Axis and [Value] to Values and set average.
Of courese, you could rename the columns.
and here is sample pbix file, please try it.
Regards,
Lin
HI @riegersn
You need to adjust your data model as below:
https://radacad.com/pivot-and-unpivot-with-power-bi
In edit queries, Selected S1,S2,S3,...S9. then unpivot them.
For example:
Now create a bar chart, drag [Attribute] to x-Axis and [Value] to Values and set average.
Of courese, you could rename the columns.
and here is sample pbix file, please try it.
Regards,
Lin
Hi @riegersn ,
I think that's because you didn't put any field into Axis,
Based on your data model, you may need to unpivot your table to show what you want.
Aiolos Zhao
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
