Sorting the matrix by multiple values

[Tlotly]

Good day

Is it possible to sort the matrix by 3 values at the same time like in Excel i.e. im my example I want Centres with all the highest % at the top. I must also mention that all the 3 values are from different tables all linked to Centre details.

Thank you
Matlotlo

[JustSayJoe]

Step 1: In your Matrix, add a field to the row hierarchy (which you will later remove).

Step 2: Change the Matrix to a Table visual.

Step 3: Sort all the columns you wish to sort, and in the order you wish them to be sorted.

Step 4: Delete the field you previously added in Step 1 from the table.

Step 5: Change the Table back to a Matrix visual.

Step 6: Ensure the right fields are back in the Row hierarchy.

This will maintain your multiple sorted fields within your matrix, even when you expand your row hierarchies.

[serpiva64]

Hi,

You have to Press Shift + Left Click on all the Headers Column you want to sort

You can refer to 

https://www.c-sharpcorner.com/article/how-to-sort-a-table-using-multiple-columns-in-power-bi/

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !

[Tlotly]

Hi @amitchandak . Thank you for the quick response but It's not working on my side 😞

[serpiva64]

Sorry, looking to your data you' ll never have Centres with all the highest % at the top because the centre with the maximun value in one column is not the centre which has the maximum value in another column. You need three different matrix in order to have the maximum of each centre

[Tlotly · Accepted solution]

@serpiva64  okay yes I see what you mean. Thank you for the response

[amitchandak]

@Tlotly , Matrix can only be sorted on one column , You can sort table on multiple column using shift