Forum Discussion
How to create a clustered column chart with multiple years
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 righ...
amitchandak
Super User
Super UserStuart123 , 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