Forum Discussion

nmck86's avatar
nmck86
Icon for Post Patron rankPost Patron
8 years ago
Solved

Manager Level Hierarchies with multiples in Power BI

HI All:   I have noticed a few posts on building Hiearchies based on manager level but havent had success replicating. I am attaching a sample file and I am hoping that someone can assist me. I wan...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi nmck86,

     

    You can try to use path function to get the hierarchy level, then use pathitem to create calculated columns to store different levels.

    Sample:

    Path = PATH('Sample'[Employee Source ID],'Sample'[Manager Source ID])

     

     

    Different level formula:

    level 1 = PATHITEM([Path],1)
level 2 = PATHITEM([Path],2)
level 3 = PATHITEM([Path],3)
level 4 = PATHITEM([Path],4)
level 5 = PATHITEM([Path],5)

     

    Create custom hierarchy:

     

    Reference link:

    Parent-Child Hierarchies

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi, 

 

If I have a table that contains like 150 project managers but not the names of their subordinates and that I have a RLS that allows these managers to only see their projects how would I create a hierarchy that would allow access to the managers' assistants to their managers' project ?

 

Thanks you in advance !