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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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