Forum Discussion
Tlotly
Helper V
4 years agoSorting 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 value...
serpiva64
Solution Sage
4 years agoHi,
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 !
- Tlotly4 years ago
Helper V
Hi amitchandak . Thank you for the quick response but It's not working on my side 😞
- serpiva644 years ago
Solution Sage
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