Forum Discussion
Anonymous
7 years agoNot applicable
Id relations
Hi,
I was looking to solve a problem i had on Power Bi Desktop.
I have a table which has this format for example:
| Employee ID | (ID AS MANAGER) | Manager ID |
| 1 | 54 | |
| 2 | 54 | 60 |
| 3 | 35 | 60 |
| 4 | 20 | 35 |
| 5 | 15 | 54 |
| 6 | 60 |
So i need a way (visualization, herarchy, groups, whatever) to show a chain of command.
I could only show which is the "Direct manager", "Employee 1" depends on "Employee 2"; but for example i couldnt related "Employee ID 1" with "Employee 6" which as you see they are indirectly related.
Hope you understand
Thanks
Regards
You can do this using the following pattern https://www.daxpatterns.com/parent-child-hierarchies/
1 Reply
- d_gosbellSuper User
You can do this using the following pattern https://www.daxpatterns.com/parent-child-hierarchies/