Forum Discussion
Reorder rows in Hierarchy Matrix visual
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
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.
1 Reply
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.