Sorting the axis

[Anonymous]

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!

[Anonymous · Accepted solution]

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]

@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]

remove sorting on Aging column if there is any

[Anonymous]

@Anonymous  There was no other sorting in it. I calculated the exact same stuff in the back end and then tried the sort in the front end and it worked.

But no clue y it did not work in the front end directly.