Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during AI Skills Fest. This week only. Secure your voucher now.

Reply
Anonymous
Not applicable

sorting in Matrix visualization

‎02-20-2020 09:02 AM

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 

Labels:
Message 1 of 4
873 Views
0
1 ACCEPTED SOLUTION
v-lid-msft
Community Support
Community Support

‎02-20-2020 11:09 PM

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:

 

7.jpg

Matrix visual:

 

8.jpg


Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

sorting-in-Matrix-visualization.pbix
Message 4 of 4
824 Views
3 REPLIES 3
v-lid-msft
Community Support
Community Support

‎02-20-2020 11:09 PM

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:

 

7.jpg

Matrix visual:

 

8.jpg


Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sorting-in-Matrix-visualization.pbix
Message 4 of 4
825 Views
amitchandak
Super User
Super User

‎02-20-2020 11:29 AM

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Message 3 of 4
838 Views
0
Daviejoe
Memorable Member
Memorable Member

‎02-20-2020 09:07 AM

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Message 2 of 4
869 Views
0

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All