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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

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.