Notifications
Clear all
Power BI
2
Posts
2
Users
0
Reactions
132
Views
Topic starter
Hi. I've tried to apply the 'sort by' trick to rows in my matrix table with no success.
I have data in a Matrix table. Column 1 is filled with rows of the client name. If you expand the client name, you can see Income and COGS... except that it's in the order of COGS and then Income which is backward to how I want it.
Is there any way to sort second-level rows in a matrix table?
Posted : 10/01/2024 3:41 pm
Hi Nate,
Select the column you wish to sort by hierarchy.
Click on the “Sort Ascending” or “Sort Descending” icon in the column header.
Choose the “Sort by Hierarchy” option from the dropdown menu.
Power BI will automatically sort the column based on the hierarchy defined in your data model.
Posted : 12/01/2024 12:19 pm