How to create a clustered column chart with multiple years

[Stuart123]

Hello

I'm trying to create a clustered column chart. The x axis has the months of the year. However, I want to be able to compare two years at once (so there is a column for January 2021 and right next to it a column for January 2022, then Feb 2021 and Feb 2022 etc).

The data for the 2 years are coming from different sheets but the variables are the same.

Thanks

[Stuart123]

Thank you @amitchandak for your reply. As I'm new to Power BI I'm not sure what this means:  

[amitchandak]

@Stuart123 , One way is month on axis and year on legend 

Month Year = FORMAT([Date],"mmm")
Month Year sort = month([DAte]) //mark this as sort column of month 

Else use month year column sorted on the column given below

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"mmyyyy")

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c