Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Solved! Go to Solution.
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
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
@Anonymous thank you....
I'm quite surprised that powerBI would not support such a basic feature...
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 38 | |
| 38 | |
| 28 | |
| 27 |
| User | Count |
|---|---|
| 124 | |
| 88 | |
| 73 | |
| 66 | |
| 65 |