Reorder Axis

[elbartje]

I got this graph:

It shows me all data of 2019,2020 en then for 2021 I see the data for each month.
I want the data in this order in my X-Axis:
2019, 2020, 2021, Jan, Feb, Mar, Apr, May, June, July, Aug,Sept, Oct, Nov, Dec
If I change my month format to 1,2,3 then my graph looks like this:

Can I sort on a column that is not in the visual, or can I add a dummy column to sort on in the graph ?

[elbartje]

Thank you that did the trick !!

[amitchandak · Accepted solution]

@elbartje , You need to create a sort order column and mark that sort column

Example

Axis column 1 = [Axis Column]

Axis column sort =  Switch(true(),

[Axis Column] = "2019", 1,

[Axis Column] = "2010", 2,

//Add others )

Mark Axis column sort as sort column for Axis column 1 and use Axis column 1 in visual

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c