CODEWITHSUNDEEP
powerbipowerbi-desktop
sarankumar
sarankumar

Reputation: 71

Multi column sort in Power BI

Is there any possibility for multiple sorting in Power BI. I have below table

**employee_name**   **status**     **Status_Count**  **Duration**
 Arun prasath          closed             2                116
 Arun prasath          open               3                565
 Arun prasath          unattended         6                1140
 Sudip                 closed             1                46
 saran                 closed             2                67

Now below is the criterias;

  i) Filter the closed status

 ii) Top status count

iii) Shortest time duration

Expected table output :

**employee_name**   **status**     **Status_Count**  **Duration**
 saran                 closed             2                67
 Arun prasath          closed             2                116
 Sudip                 closed             1                46

Can anybody help me??

Upvotes: 3

Views: 5300

Answers (1)

nanda
nanda

Reputation: 31

You can do this in the query editor with this formula:

= Table.Sort(#"Renamed Columns",{{"Status", Order.Ascending},{"Status_count", Order.Descending},{"Duration", Order.Descending}})

Here's a screenshot of the result:

enter image description here

Upvotes: 2

Related Questions