cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Akshaya Member
Member

Sorting the axis

I have the following visual:

 

Sorting Doubt.PNG 

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

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

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

Akshaya Member
Member

Re: Sorting the axis

@reddy_powerbi 

 

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:
Sorting Doubt.PNG

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

Sorting Doubt. 2 PNG.PNG

So there is no change

Re: Sorting the axis

remove sorting on Aging column if there is any

Akshaya Member
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.