Grouping Cluster Chart by Year

[Daft_Ada]

Hi, I'm trying to replicate a cluster chart graph and getting nowhere fast. It is used to compare monthly sales YoY (so Jan 2020 v Jan 2021 v Jan 2023 etc.)

Very easy to make in Excel but I'm a new PBi user and I just can't get this to be replicated.

This is the best I have achieved so far:

 

I have followed tutorials to create new columns for Month and Year, but it is still not behaving as I'd expect.

Can anyone suggest? Is it an easy option I'm not aware of or more complex? Thank you in advance!

[amitchandak · Accepted solution]

@Daft_Ada , For the first visual, month on axis and Year on the legend of clustered column visual

[Daft_Ada]

Thank you so much! I thought it would be an easy fix 🙂