Forum Discussion
How to get line chart sorted by month?
Hi ruidi1126
It is necessary to define the sorting method through the data table in order for our visualizations to know how to sort the months chronologically.
In accordance with the month's number.
Please see the attached image.Here is a link short video explaining how it works:
https://www.youtube.com/watch?v=NvFDasTzP9E
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Memorable MemberHi ruidi1126 ,
The reason here is, you have alphabetical ordering and the ordering is descending, which means instead of A-B-C it goes othe way around C-B-A. In your case M is then at the beginning.
Change the order in Ascending or even better, create a new column, where you have following logic:
January = 01
February = 02
March = 03
Etc.
Then select your Month column and use Sort By option in the settings of the column and use your new column for sorting by. With this set up, order will not be alphabetical but numerical.
In case you would struggle, let me know and I can provide some printscreens and examples.
Thanks.