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 Joe_Barry
thank you for your reply. I tried the index column but I receive the follow message when I try to sort the order date column according to the index
I assume this pops up because I several entries have the same date but a different index value. Do you happen to know how to deal with this?
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")