Drill-through to show all direct and indirect reports (Hierarchy)

[judspud]

Hi,

I am trying to create a report containing a hierarchy that is able to drill-through to employee details for everyone under the manager.

I have created a drill-through to show direct reports but I want to be able to see every employee underneath, not just the direct reports.

I have two columns of data; Employee and Manager.

This links to a line by line table on the employee column.

Currently using the Sankey Chart custom visual to display the hierarchy.

For example, If i drill through on Employee 4, I want to be able to see Employees: 16, 17, 18, 19, 20 and 15.

Any help would be appreciated.

I am open to using a different visual to display this however if it is a custom visual it must be Power BI Certified.

Thanks,

George

[v-yanjiang-msft]

Hi @judspud ,

If you want to drill through all the direct and indirect employees, I think maybe first you should list all the direct and indirect employees and the corresponding manager in a new table. To calculate all the employees, please refer to this thread:  Solved: how to get direct and indirect employees count - Microsoft Power BI Community

Best Regards,
Community Support Team _ kalyj

If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.