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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors