Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sorting the axis

I have the following visual:

 

 

The axis is in a really messy order whether i sort is ascending or descending.. is there a way to sort it such that it is in the order:

 

<60

>60

>90

>120

>180

 

The axis is a column called Aging that is created as follows:

 

Aging = SWITCH(TRUE(), REQUISITION[Age Days]<60, "<60", REQUISITION[Age Days]>60 && REQUISITION[Age Days]<=90, ">60", REQUISITION[Age Days]>90 && REQUISITION[Age Days]<=120, ">90", REQUISITION[Age Days]>121 && REQUISITION[Age Days]<=180, ">120", REQUISITION[Age Days]>180, ">180")
 
Any help on this? Thank you in advance!
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    7 years ago

    create another custom column and set values accordingly and sort by custom column

    like this......

    when value is        custom column

    <60                                 1

    >60                                 2

    >90                                 3 

    >120                               4 

    >180                               5

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    create another custom column and set values accordingly and sort by custom column

    like this......

    when value is        custom column

    <60                                 1

    >60                                 2

    >90                                 3 

    >120                               4 

    >180                               5

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Anonymous 

       

      Hey I created a new column as follows:

       

      Aging Sort = SWITCH(TRUE(), REQUISITION[Aging]="<60",1,REQUISITION[Aging]=">60",2, REQUISITION[Aging]=">90",3,REQUISITION[Aging]=">120",4,REQUISITION[Aging]=">180",5)
      But when I try to sort Aging with this now it throws the following error:

      When I try to Sort Aging by this column  it shows this:

      So there is no change

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        remove sorting on Aging column if there is any