Group Months in Bar Chart

[Anonymous]

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.

[Bokazoit]

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

[Anonymous]

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

[Bokazoit]

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

[Anonymous]

@Bokazoit

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

[Anonymous]

@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?