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.? ...
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
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
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 ?