Forum Discussion
Tlotly
4 years agoHelper V
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 value...
serpiva64
4 years agoSolution Sage
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
4 years agoHelper V
Hi amitchandak . Thank you for the quick response but It's not working on my side 😞
- serpiva644 years agoSolution 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