How to get line chart sorted by month?

[ruidi1126]

I have selected to sort axis by month but why is March still showing before the other months? Any help is appreciated.

[Ritaf1983 · Accepted solution]

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.

[ruidi1126]

Hi,

I followed your instruction but got the following error message. Do you know how to resolve it?

Thanks,

Rui

[Migasuke]

Hi @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.

[ruidi1126]

Thanks.