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 ,
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 Anonymous
thank you for your response! this was the solution! 🙂