Forum Discussion
Custom Sort for PBI matrix rows
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
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
The problem is, the moment I remove the sort column from the visual, it reverts to alphabetical sorting of sub class code
cannot reproduce. You need to use the menu item as indicated.
Hi adityah ,
Please check if you are using sort by column correctly, I have made simple sample, you can check the attachment.
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.