Dynamically change x axis according to RLS

[Anonymous]

Hi All, 

I have 4 levels of hierarchy: 

1st: VP Level 

2nd: Director

3rd: Department

4th: Employees 

I have a report that tracks the number of hours that employee are working in a column chart. However, on the X axis I would like to dynamically display one level lower according to which level of user is signing in. For e.g., if VP level signs in then the x axis should show director level, if director signs in then it should show department level, if department signs in then employees etc.   How can implement this? 

Thanks a lot in advance 🙂 🙂 

[v-eqin-msft]

Hi @Anonymous ,

For Dynamic Row Level Security with Hierarchy case, you may refer to these blog:

https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi

https://radacad.com/dynamic-row-level-security-in-power-bi-with-organizational-hierarchy-and-multipl...

https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies

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

[danielwelch]

Hi Evko,

Create a new calculated column in hours table identifying who can see what i.e if - role is lowest then All, Else if next level then Department, Else Director, Else VP.

Then filter your RLS for each user based on the new column, this will then remove any data they are not authorised to see from the sales table and update your visualisation.

Hope this helps.