Forum Discussion
Employee supervisor hierchy
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
3 Replies
- jaideepnema
Solution Sage
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 😀
jaideepnema If I have a result column like this how can i make use of it in a matrix visual to show an hierachy?
v-xiaotangCommunity Support
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.
