sorting in Matrix visualization

[Anonymous]

Hi Experts ,

I have matrix visualization where I need sorting on column

as currently I m getting the result as below 

          State 

Team   Awating User    On hold     In progress 

MM         1                            2                4 

FI             4                          5                   5

BI             5                         3                   4 

However,  I need  "In progress" as 1 st column   ,  "Awaiting user " as 2 nd  and On hold as 3rd  .

Kindly suggest .

Regards,

Ganesh Jagdhane 

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

We can create two calculated column, then use Status_2 Column to sort by rank column and use Status_2 Column as column header to meet your requirement:

Calculated Columns:

Status_2 = [Status]

Rank = SWITCH([Status],"In progress",1,"Awating User",2,3)

Sort by:

Matrix visual:

Best regards,

[amitchandak]

Can you share sample data and sample output.Thanks.
Proud to be a Datanaut My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[Daviejoe]

Hi,

I'm not sure how your data is structured to answer properly, does the below help?

https://community.powerbi.com/t5/Desktop/Matrix-Column-Head-Order/m-p/71851#M29775

All the best David