Forum

Sorting Rows in a m...
 
Notifications
Clear all

Sorting Rows in a matrix (not columns)

2 Posts
2 Users
0 Reactions
132 Views
(@naterook)
Posts: 19
Eminent Member
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.SortbyOrder.JPG

Is there any way to sort second-level rows in a matrix table?Matrix-2nd-level-Row.JPG

 
Posted : 10/01/2024 3:41 pm
(@catalinb)
Posts: 1937
Member Admin
 

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
Share: