Forum Discussion
Filter set based on user login
I have a regional based report. There are 5 regions, 3 in one Island, 2 in another. Each region has a manager. All the managers are allowed to see the detail for the other regions in their Island.
What I want to do is have the reports default to the managers region when they login with the other regions an option in the slicer. I have the RLS working fine. The endpoint I want is:
Island 1
- when manager 1 logs in the reports will be filtered to Region 1 but have region 2 and 3 as options,
- when manager 2 logs in the reports will be filtered to Region 2 but have region 1 and 3 as options
- when manager 3 logs in the reports will be filtered to Region 3 but have region 1 and 2 as options
Island 2
- when manager 4 logs in the reports will be filtered to Region 4 but have region 5 as an options
- when manager 5 logs in the reports will be filtered to Region 5 but have region 4 as an options
Is there any way to achieve this?
pmhoang94, the RLS is working fine the problem I have is a presentational one. The aim is that the filter is set to one of up to 3 options based on login.
12 Replies
Hi samdthompson,
You can reference: https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/
pmhoang94, the RLS is working fine the problem I have is a presentational one. The aim is that the filter is set to one of up to 3 options based on login.
Hi samdthompson,
I think dynamic RLS will be suitable for your requirement, you can take a look at below article:
Power BI – Dynamic Row Level Security – Tips to get it working!
Regards,
Xiaoxin Sheng
I would love to be able to do this too. I want to select the manager's department when they first open the dashboard.
RandomJoe Hi Its now a doable thing using either bookmarks or filters that save as they were during the last login by user.
Can you expand on this? We have about 400 managers, so does that mean I need to create 400 bookmarks?
