Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
Hello @pra137 ,
Yes, it is possible with your data.
You can see the solution with dummy sales data below:
Thanks,
Neel
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..?
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
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
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 ?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
58 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |