Forum Discussion
Sorting the matrix by multiple values
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
6 Replies
Tlotly , Matrix can only be sorted on one column , You can sort table on multiple column using shift
Hi,
You have to Press Shift + Left Click on all the Headers Column you want to sortYou can refer tohttps://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 !
Hi amitchandak . Thank you for the quick response but It's not working on my side 😞
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
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.
