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
You want to change the sub class order but keep the value sort? How would that work?
edited
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