Forum Discussion
Hierarchy data in matrix visual
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
- Anonymous4 years ago
Hello Anonymous ,
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
5 Replies
- AnonymousNot applicable
Hello Anonymous ,
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-6ef5cf385016.xhtml
Thanks,
Neel- AnonymousNot applicable
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 ?
ā
- AnonymousNot applicable
Hello Anonymous ,
Yes, it is possible with your data.
You can see the solution with dummy sales data below:
Thanks,
Neel- AnonymousNot applicable
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..?
- AnonymousNot applicable
Hello Anonymous ,
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