Forum Discussion
webportal
9 years agoImpactful Individual
Order multiple columns in a matrix
How can I order the following matrix by two criteria: By month Then, by "pagamento", smallest to largest Then by "recebimentos", largest to smallest
Anonymous
6 years agoNot applicable
If you have the latest version of PowerBI desktop you can do this in 5 following steps:
Step 1: Convert the matrix into a table
Step 2: Sort the table by "Month" 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 "Pagamento" column (Shift + Lift Click again to change sort order to opposite direction)
Step 4: Now again add an additional sort in the table by pressing Shift + Lift Click on "Recebimentos" column
Step 5: 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
RAC_GAVIN
3 years agoFrequent Visitor
This did not work for me.