Forum Discussion
Anonymous
6 years agoNot applicable
Sort multi columns in Matrix table
Hi All, Does anyone know if it's possible to sort multi columns in Matrix table? Regards BK
Anonymous
6 years agoNot applicable
If you have the latest version of PowerBI desktop you can do this in 4 following steps:
Step 1: Convert the matrix into a table
Step 2: Sort the table by "First" column (Click again if you want to change the sorting order in opposite direction)
Step 3: Now add additional sort in the table by using Shift + Lift Click on "Second" column (Shift + Lift Click again to change sort order to opposite direction)
Step 4: Convert the table back to matrix now, and your matrix retain these sort orders now
If this helps you then please give a thumbs up to the solution
- Jeanxyz3 years agoPower Participant
Thanks for sharing. However, I failed a step 4. When i convert the flat table back to matrix, the matrix only keep sorting of 2nd column.