Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
mdebekke
Frequent Visitor

Sort Column values Matrix percent of row total

When creating a Matrix visual , I would like to know the percentage of recharge per resource. In my Data these values are hours (whole numbers). In the Matrix I turn these hours into percent of row total to have percentage values per resource. After doing that I can't sort on these percentage values in the Matrix. (see sceenshot). I would like to have the highest NO percentage on 1st place sorting from there to the lowest value. Someone here who has a bypass for that via some code?

 

I already have added this as idea to solve in next updates if voted enough 🙂

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/35022397-sorting-on-columns-in-ma...

 

Matrix visual.PNG

1 ACCEPTED SOLUTION
mdebekke
Frequent Visitor

By using the measures given as answer in below post I'm also able to sort on the columns:

https://community.powerbi.com/t5/Desktop/Conditional-formatting-matrix-percent-of-row-total/m-p/4826...

 

This one is solved also thanks to @bidevsugmen

 

Sort per clumn Matrix Solved.PNG

 

View solution in original post

1 REPLY 1
mdebekke
Frequent Visitor

By using the measures given as answer in below post I'm also able to sort on the columns:

https://community.powerbi.com/t5/Desktop/Conditional-formatting-matrix-percent-of-row-total/m-p/4826...

 

This one is solved also thanks to @bidevsugmen

 

Sort per clumn Matrix Solved.PNG

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.