Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Need Help Visualising Hierarchy

Hi All,

 

I was hoping someone would be able to help me with a problem I've been having whilst trying to create an org chart hierarchy to visualise in a Power BI report.

I am trying to show ALL of the employees who are subordinate to the selected employee, however I can only seem to show the direct reports, i.e. the one level below the selected person in the hierarchy. I have created a path of max 8 hierarchy levels which all seems to be working fine:

 

PATH = PATH('EMP'[EMPLOYEE_INDEX],'EMP'[PARENT_INDEX])


which is then split into 8 hierarchy levels:

 

Level 1 = LOOKUPVALUE('EMP'[EMPLOYEE_INDEX],'EMP'[EMPLOYEE_INDEX], PATHITEM('EMP'[PATH],1,1))

I'm trying to display all of the employees under this person selected in the search bar in a table, and also get a total in a stacked bar chart (see picture).
 
 
While the table currently shows 7 employees reporting to employee '6993', there should be around 250 total.
 
Link to pbix & data 

Any ideas on how to display this properly?

Thanks,
Tom
Need Help

3 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    Anonymous ,

     

    Please try to use "Ultimate Decomposition Tree" custome visual from Market place.

     

    Please give KUDOS and accept this as a solution if it helps you!

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Tahreem24 ,

       

      Thank you for the response.

       

      Apologies but I'm quite new to this so I'm a little confused by the visual you mentioned, could you possibly provide some guidance on which fields i should place in each data category to get the desired result?

       

      Thanks

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        In fact looking at the Ultimate Decomposition Tree visual, this may be too cumbersome for what I am looking for, as some line managers will have a huge number of reportees and these will need to be displayed in a table, along with their compliance. My issue is that I cannot seem to get a table or stacked chart to correctly display all the non-direct reports along the hierarchy also.

         

        Is there any way around this or am I stuck with only being able to display direct reports?