cancel
Showing results for
Did you mean:
Highlighted
Member

## 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!
1 ACCEPTED SOLUTION

Accepted Solutions
Member

## Re: Sorting the axis

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 4
Member

## Re: Sorting the axis

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

Member

## Re: Sorting the axis

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

Member

## Re: Sorting the axis

remove sorting on Aging column if there is any

Member

## Re: Sorting the axis

@reddy_powerbi  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.