Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
mds123
Frequent Visitor

How can I compare two different columns in a bar chart?

I remember (could be wrong) that there was an option on the clustered column chart to place columns in "value". This would allow the x axis to have different categories but with two columns for each category. For example, an actual performance and target performance. Is this no longer available or is there another way to display this? 

 

Here is an example of the chart I'm trying to make.

 

mds123_0-1693924402058.png

 

1 ACCEPTED SOLUTION
george_o0802
Regular Visitor

george_o0802_0-1693924583151.png

Something like this?

If so, I have value in the Y axis, the attribute (very low, low, med etc.) in the legend and then I have the attribute and the time period both in my X axis. The attribute is at the top and the period is at the bottom as I wanted to attribute to take precedence in the visualisation.

View solution in original post

2 REPLIES 2
george_o0802
Regular Visitor

george_o0802_0-1693924583151.png

Something like this?

If so, I have value in the Y axis, the attribute (very low, low, med etc.) in the legend and then I have the attribute and the time period both in my X axis. The attribute is at the top and the period is at the bottom as I wanted to attribute to take precedence in the visualisation.

Oh, and this is a stacked column chart. 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

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.

Top Solution Authors
Top Kudoed Authors