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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Group Months in Bar Chart

I am looking to group months in a bar chart. I have 2014-2016 data and would like to see the Months together for YOY comparisons. Can't figure it out with any configurations I try as far as the Shared axis or Column series.

5 REPLIES 5
Bokazoit
Continued Contributor
Continued Contributor

Have You tried creating a column called Year and entered that into the legend part?

Anonymous
Not applicable

Capture.PNGCapture1.PNG

 

Yes.. Here are the results i get. Can't lump the months together it seems

Bokazoit
Continued Contributor
Continued Contributor

The issue is the shared axis that has month as primary, they need to share the same year column

Anonymous
Not applicable

@Bokazoit

 

I am not sure what that means.. Can you walk me through how I fix this?

Anonymous
Not applicable

@Bokazoit

 

Not sure if this has anything to do with it, but I am not given a date hierarchy when dragging the Month in. My data is an import, not a direct query, so it should have hierarchy, correct?

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.