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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.