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
you can use matrix visual,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @sowmyar ,Create a calculated column like this:
Hierarchy Check = CALCULATE(CONCATENATEX('Table','Table'[Employee],"-"),ALLEXCEPT('Table','Table'[Supervisor]))
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?
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.