Forum Discussion
Reverse Company Hierarchy
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!
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.
2 Replies
- edhans
Community Champion
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. - Icey
Community Support
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.
