Forum Discussion
Sorting in the Matrix Visual
I have a matrix visual with two fields in the rows well: 1. Staff Member Code 2. Staff Member Title I would like users of the report to be able to sort by either of these columns independant...
Hi SamRobinson120 - Power BI’s Matrix visual does not natively support independent sorting of child groupings. However, here are some possible workarounds:
Option 1: Enable Sorting in a Table Visual + Sync with a Matrix
Since the Table visual allows independent sorting, you can:
Create a separate Table visual with only "Staff Member Code" and "Staff Member Title".
Allow users to sort the Table independently.
Use the Sync Slicers feature to ensure that the sorted staff list matches the data in the Matrix.
Hi, thanks for responding.
How would a separate visual work if you need to scroll vertically through a list? Won't you just end up scrolling in one visual but not the other or am I missing something?
