Reorder rows in Hierarchy Matrix visual

[Chennakesava458]

Hi Team,
    Based on  below sample data 

GL-2              GL-3          GL-4     Sales

employee1	Manager1	Client1	1500
employee2	Manager2	Client1	2500
employee2	Manager1	Client1	4000
employee4	Manager2	Client1	6800

if we create Matrix visual 

But my requiremnt is 

employee1    1500
employee2    4000
Manager1     5500
employee2    2500
employee4   6800
Manager2    9300
Client1        14800

Anybody Suggest how to achieve this

[Ritaf1983 · Accepted solution]

Hi @Chennakesava458 

Unfortunately, it is not possible to achieve the exact layout as shown in the image you attached using a matrix visual in Power BI.

However, it is possible to modify the position of intermediate summaries and display them at the bottom.

The pbix with examples is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.