Reverse Company Hierarchy

[Anonymous]

Hi Everyone,

I am trying to work on a way from the Top Down for my organization. I have every employee and their supervisors all the way up to the CEO. But every employee's supervisor list differs so the CEO isn't on the same column. I want to reverse the heirarchy so that a new column is created where the CEO is on the same column for everyone, and then work down for each employee (SVP, VP, Mgr, etc.). I can do it in excel using a match index formula, but not sure how to do that here in Power BI. Thanks for your help!

[Icey · Accepted solution]

Hi @Anonymous ,

Do you want to set up RLS for your data model?

If so, this post may help you: Dynamic Row Level Security with Organizational Hierarchy Power BI.

If not, please share us more details.

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[Icey · Accepted solution]

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[edhans]

Can you provide some sample data per links below, along with what the expected result is?

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.