Forum Discussion
Anonymous
7 years agoNot applicable
Matrix Mutli tier sorting
Hi
trying to find a way to do multi level sorting in a Matrix I came up empty. it is true that this feature is not supported !!!!
are there any workarounds?
BR
Chronis
- Anonymous7 years ago
Hi Anonymous ,
Current power bi not support apply multiple sorting orders on matrix, you can refer to following link to create a custom sort order table to apply multiple column sorting:
Custom Order= COUNTROWS ( FILTER ( Table, ISONORAFTER ( [Column1], Table[Column1], DESC, [Column2], Table[Column2], DESC, [Column3],Table[Column3], ASC ) ) )Regards,
Xiaoxin Sheng
2 Replies
- AnonymousNot applicable
Hi Anonymous ,
Current power bi not support apply multiple sorting orders on matrix, you can refer to following link to create a custom sort order table to apply multiple column sorting:
Custom Order= COUNTROWS ( FILTER ( Table, ISONORAFTER ( [Column1], Table[Column1], DESC, [Column2], Table[Column2], DESC, [Column3],Table[Column3], ASC ) ) )Regards,
Xiaoxin Sheng- AnonymousNot applicable
Anonymous thank you....
I'm quite surprised that powerBI would not support such a basic feature...