Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sorting months in chronological order

Hi everyone   I know this question has been asked a lot but I'm really struggling getting a line cgart to displa the months in chronological order rather than alphabetical.  I have followed the ins...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago
    Anonymous Please try to change the datatype of MonthNo field to Numeric. Then use "Sort by Column" option to sort the Month by MonthNo (Select Month Field and then use "Sort by Column" option to use MonthNo as sort order)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous.

 

You can add a 0 before the number from 1 to 9 to get the correct order doing a simple transformation in Query Editor. 

 

Text.PadStart([MonthNo], 2, "0")

 

Regards,

 

Marcos Pérez