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
webportal
Impactful Individual
Impactful Individual

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

Capturar4.PNG

5 REPLIES 5
Anonymous
Not 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 

This did not work for me.

Sean
Community Champion
Community Champion
webportal
Impactful Individual
Impactful Individual

@Sean

Still a long way to go in Power BI!

@webportal

 

Interactive sorting is not supported in Power BI Desktop. Please submit a feature request on Idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Regards,

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.