sort Year Month axis in charticulator

[Jeanxyz]

I need to create a line chart in charticulator. My x axis is Year Month from Dim_Date table, I want to sort Year Month by ascending order, something like 2021/Jan, 2021/Feb.... 

In charticulator Plot attributes, I have set up X axis to be  sorted by Yearmonth number (integer format), but it doesn't seem to work. 

[Jeanxyz · Accepted solution]

I figured it out. instead of sort Year Month Short by YearMonthNumber (integer), I should sort by YearMonthNumber_Text. 

so I have created a new column in Dim_Date tabel

YearMonthNumber_Text=convert([YearMonthNumber],String)

and use this new field to sort chartculator

click sort