Forum Discussion
Solved
Custom Sort for PBI matrix rows
Hi Guys, Posting this here since none of the previus solutions seem to be working. I have a power bi matrix which looks like this: Sub Class Code 2022 2023 CAO 1 1 CAT 2 2 CFF ...
1. add a sort column
2. bring your data into a usable format by unpivoting
3. use the "sort a column by another colum" function to sort the Sub Class Code by the Sort column.
4. Render the data in a matrix visual
Could you please explain on what basis you trying to sort the sub class
Its a custom sort order that is required. The report user wants to see his rows in this order as mentioned in the question.
