Hierarchy data in matrix visual

[pra137]

Hii guys

I want to show manager data n his sales person data in Hierarchy..eg when i click on manager below that i can see his sales persons data n his own data it is possible in matrix visual.?

Please help

Thanks

Pra137

[Anonymous]

Hello @pra137 ,

Yes, it is possible with your data.

You can see the solution with dummy sales data below:

Thanks,
Neel

[pra137]

Yes it is correct but A sales person is under the G manager so A as a sales person unable to shown in under Manager A Hierarchy..is it possible with this dataset..?

[Anonymous · Accepted solution]

Hello @pra137 ,

For the levels of hierarchy, you need to add one super-manager column in your dataset to clarify who is the super-manager of the manager.

So to implement this your dataset should look like this:

Thanks,
Neel

[Anonymous]

Hello @pra137 ,

We can achieve it easily in matrix visual if you have proper data with related manager names in front of salespersons in the table.
For more info follow this link: https://www.oreilly.com/library/view/microsoft-power-bi/9781788290142/2dd4c014-6801-47ab-bb6a-6ef5cf...

Thanks,
Neel 

[pra137]

Hi @Anonymous

My data is like below table I can see the Hierarchy like manager and below his sales persons data but i also want to see manager's data in his Hierarchy is it possible ?