Forum Discussion
Need help in sorting with a Matrix visual
Hi there,
In a Power BI Matrix, you cannot directly sort by fields in lower levels of a hierarchy from the UI. The official solution is to use Sort by Column:
Add a calculated column (or a column in your table) that contains the sort order for the field you want to sort.
Select the field in the Rows → go to Column tools → Sort by column → choose the new sort column.
This allows you to sort any row field without adding it to the Values section.
Official Microsoft Reference:
Power BI: Sort a column by another column
Did it work? ✔ Give a Kudo • Mark as Solution – help others too!
Regards,
Rufyda Rahma | Microsoft MIE
Hi Amit
Thanks for quick response . Really appreciate it . Still its not working . Maybe I am doing somehting wrong hence wanted to check the PBIX file , but its not opening saiying it has some custom calender not supported in my system .
Can you elaborate the steps a little bit
ashwinkolte , removed the new calendar and attached the file.
Hi Amit , I saw the file . Thankyou so much for sharing . Since a slicer is used , it removes all other fields when any one is selected (e.g category, sub category, brand etc ) . My requirement is that all "Rows" fields should be visible and it should sort the entire table based on the field selected/desrired . Is this possible
ashwinkolte , NO, I doubt that is possible.
