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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.