X-axis Timeframe Sorting Issue

[gabrielmission7]

Hello,

I have a "Line and Stacked Column Chart" with X-axis running as timeframe that is currently ordered as follows:
2015, 2016, 2017, 2018, 2019-01, 2019-02, ... , 2019-12

I'd like to rename them as follows:

FY 2015, FY 2016, FY 2017, FY 2018, Jan, Feb, ..., Dec

However, as soon as I change to the renamed format, the sorting is all messed up. Any suggestions?

TIA!

Gab

[gabrielmission7]

Great tip, @mahenkj2 ! Thanks for the suggestion. It works like a charm.

[mahenkj2 · Accepted solution]

Hi @gabrielmission7 

In such coditions, you may use an additional column with sorting order as desired and sort the x-axis column with this sort column.

Please let me know if it is clear enough for you. Search 'Sort by column' furnction report page:

Hope it helps.