Employee supervisor hierchy

[sowmyar]

I've attched a screenshot of sample data,where I've supervisor and employee.I want to get the list of employee under a supervisor, the next level of subordinates and so on.

For instance 12(superviosr)->1,2,3,4,5 and under 1->6,7 under 7->9,10 this to a specific date range

Thanks in advance

[v-xiaotang]

Hi @sowmyar 

you can use matrix visual, 

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

Best Regards,

Community Support Team _Tang

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

[jaideepnema]

Hi @sowmyar ,
Create a calculated column like this:

Hierarchy Check = CALCULATE(CONCATENATEX('Table','Table'[Employee],"-"),ALLEXCEPT('Table','Table'[Supervisor]))

which will give you the desired results:

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

[sowmyar]

@jaideepnema If I have a result column like this how can i make use of it in a matrix visual to show an hierachy?