Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

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

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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
Not applicable

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

Anonymous
Not applicable

remove sorting on Aging column if there is any

Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.