Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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
25460
33560
42035
51554
660 

 

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