Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Chennakesava458
Frequent Visitor

Reorder rows in Hierarchy Matrix visual

Hi Team,
    Based on  below sample data 

GL-2              GL-3          GL-4     Sales

employee1Manager1Client11500
employee2Manager2Client12500
employee2Manager1Client14000
employee4Manager2Client16800

 

if we create Matrix visual 

Chennakesava458_0-1715927265447.png

 

But my requiremnt is 

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

Anybody Suggest how to achieve this

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

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.

Ritaf1983_0-1716095427473.png

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.

View solution in original post

1 REPLY 1
Ritaf1983
Super User
Super User

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.

Ritaf1983_0-1716095427473.png

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.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.