Row level security for a manager

[mgusty33]

I have a line graph that shows total number of tickets for a department. We would like to have the manager have access to filter it by person to see the individual ticket results, so I have a slicer on the page to narrow it down to the individual level. However for the members of the team, I would only like them to be able to see overall graph and not be able to narrow it down. 

I have tried using row level security, and hide the "Team Member" for the team memebers, but that hides all the rows that have a team member value. 

If there is a way to hide certain pages (which I am pretty sure there is not based on what I have seen online), or some other method so that only the manager can break it down to specific people, that would be ideal! If anyone has any idea how to do so, any help would be great. 

Thank you!

[v-yulgu-msft]

Hi @mgusty33,

Since the manager should have access to all department data, while team members can only view their own data, you should apply Row Level security.

Reference: 
Row-level security (RLS) with Power BI

Dynamic Row Level Security with Manager Level Access in Power BI

Power BI – Dynamic Row Level Security – Tips to get it working!

For the problem "I have tried using row level security, and hide the "Team Member" for the team memebers, but that hides all the rows that have a team member value.", you could calculate the total number of tickets via calculated column rather than measure.

Please see the difference between measure and column.

Best regards,

Yuliana Gu

[mgusty33]

It is not that I want them to only be able to see their data, but I want them to be able to see the collection of the whole team but not be able to narrow it down to specific people. Only the manager would have the ability to narrow it down to specific people via the slicer. 

[v-yulgu-msft]

Hi @mgusty33,

Currently, it is not possible to disable the drill down action to specific users. I'm afraid your requirement cannot be achieved now.

Regards,

Yuliana Gu