Forum Discussion

webportal's avatar
webportal
Impactful Individual
9 years ago

Order multiple columns in a matrix

How can I order the following matrix by two criteria:

  1. By month
  2. Then, by "pagamento", smallest to largest
  3. Then by "recebimentos", largest to smallest

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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