Double Sort

[learner03]

How can sort below by Picking first...then Ready and then Allocated. Also, the second sort by Job create time from ascending to decending. I mean where the job status will be picking, there time would be Asc to Dsc...and so on.

@amitchandak @Fowmy 

[v-janeyg-msft · Accepted solution]

Hi, @learner03 

You need to create two column to show the sort results you want.

Like this:

Column = IF(Table1[job status]="Picking",1,IF(Table1[job status]="Ready",2,3))

rank = RANKX(Table1,RANKX(Table1,[Column],,DESC)*1000+RANKX(Table1,[jbo create time],,ASC,Dense))

Reference:

RANKX function (DAX) - DAX | Microsoft Docs

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,

Community Support Team _ Janey

[amitchandak]

@learner03 , In the table visual you can click on another column with shift and sort that too.

Click on the column, what you want to sort , once or twice. Then press shift and click on another one

[learner03]

@amitchandak @Fowmy  If I click on Status  coloumn, then it sort alphabatically. But, I want it to be by Picking..Ready ..Allocated. How can I do that?