Forum Discussion
Sorting Month Axis by chronological order
Hi ThomasSan ,
Thanks Joe_Barry for the quick reply. I have some other thoughts to share:
1.We can create a new table.
Month Number 2023-August 1 2023-September 2 2023-October 3 2023-November 4 2023-December 5 2024-January 6 2024-February 7 2024-March 8 2024-April 9 2024-May 10 2.We can create a [Year-Month] column in table.
Year-Month = YEAR([Date]) & "-" & FORMAT([Date],"mmmm")3.We can create a model relationship.
4.Select the [Month] column to sort by number column.
5.Place the field as shown in the following image.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi ThomasSan
Ok delete the index and add this conditional column in Power Query and Format the column into Whole Number
Text.From(Date.Year([Date]) ) & Text.From(Date.Month([Date]))
Sort by that column instead
But I'm thinking you may need to go down the Year/Month route in your visual.
Still do the above and in theTable view add a column then sort by the column above. You can adapt the formatting to suit your needs. I think without the context of the year, it won't be possible to achieve what you need, but I stand to be corrected
Year/Month = FORMAT(Incidents[DateUTC], "YY - MMM")
