Forum Discussion
Arrange stacked chart by month
Hello, I have live dataset showing onto a stacked chart. The thing is it is arranged by alpha. not by month, I can't see how I can change this? any ideas please?
Ashish_Mathur
Super User
Super UserHi,
You must have a Calendar Table and build a relationship from the Date column of your Data Table to the Date column of your Calendar Table. In the Calendar Table, create the following calculated column formulas
Year = Year(Calendar[Date])
Month Number = Month(Calendar[Date])
Month Name = FORMAT(Calendar[Date],"mmmm")
Click on any cell in the Month Name column and click on Sort By > Month Number.
To your visual, drag Year and Month from the Calendar Table.
Hope this helps.