What are the best visuals to represent company employee and managers Hirearchy?

[Anmolgan]

I used this link to build a hirearchy of a company: 

https://blog.jameyjohnston.com/row-level-security-in-power-bi-using-parent-child-hierarchies/

Now the problem is I am looking for the best visualization so that I can represent this hirearchies correctly may be a nested slicer or tree chart will work but i am not getting anything to work here.

Also how can I test out this in the PowerBI Desktop, I dont have the correct userid to lookup to I only have the complete email ID of the employees, how can I write the role so that user should see there own data according to the hirearhcy whenever they login to the PowerBI Service?

[sarveshpandey23]

I'm facing the same issue. 

[v-yuta-msft]

@Anmolgan ,

You need to build hierarchy RLS using PATH() function, you may refer to: https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi.

You may use hierarchy slicer to view the organization member. https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380820?tab=Overview

Community Support Team _ Jimmy Tao

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

[Anmolgan]

@v-yuta-msft  Thanks for the response, how can validate this in powerbi desktop, I have built out the path function, but not sure how to validate this in powerbi service and powerbi desktop

[v-yuta-msft · Accepted solution]

@Anmolgan ,

You need to create an additional UPN table and create a RLS role in power bi desktop and using the PATH() function. In power bi service, you need to add the user email to that role.

Please refer to: https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

Community Support Team _ Jimmy Tao

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