Load chart based on Row Level Security

[SimonSeez]

Hello, 

I implemented Row Level Security on my report and I have three main rows. An overall Head, an Area Manager and a Branch Manager. They all use the same dashboard but I want the chart below to change and display based on their roles. Currently it shows only by Areas and users who are not area managers have to drill down to view. I want to remove that extra step as it requires training. 

For instance,

When the branch Manager logs in, they should see the chart showing their branch and not based on zone their branch belongs to.   See below 

[Icey]

Hi @SimonSeez ,

Please refer to these similar blogs:

Dynamic Row Level Security with Manager Level Access in Power BI;

Dynamic Row Level Security with Organizational Hierarchy Power BI.

Best Regards,

Icey

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

[MFelix · Accepted solution]

Hi @SimonSeez ,

check the blog below maybe it can give you some help on achieving a workaround.

http://www.fourmoo.com/2020/05/26/did-you-know-you-can-now-selectively-show-report-pages-for-specifi...

[SimonSeez]

Thank You @MFelix 

This worked! Appreciate.