Need Help Visualising Hierarchy

[TWorthy91]

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

[Tahreem24]

@TWorthy91 ,

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!

[TWorthy91]

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

[TWorthy91]

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?