The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Solved! Go to 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
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
@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
@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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |