Forum Discussion

elbartje's avatar
elbartje
Frequent Visitor
4 years ago
Solved

Reorder Axis

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, Jun...
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

amitchandak's avatar
amitchandak
Super User
4 years ago

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