Forum Discussion
Filter set based on user login
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
Anonymous, The RLS is working. This is a presentational issue. When the manager of region one logins I want the region slicer to default to:
with all the other regions available for them to click if they wish.
If the manager of region 2 login they will see:
As far as i know this is not an RLS thing. This is a defult slicer setting based on login.
Thanks,
Sam
Hi samdthompson,
Current slicer not support setting default value. In addition, power bi service not support analyze the location, I think you can send these requirement to ideas.
Regards,
Xiaoxin Sheng
samdthompson were you able to get the solution for this thread ? if yes, could you me help with the solution?
Its not possible based on the expert opinions I have had (4 MVPS's who all had access to the entire file). The work around i have used in the end is to use the persistent filter capability in PBI service. I had only a limited number of users so was able to set up the filter criteria then the next time they logged in it was all the same. Its not quite perfect as they could so easilsy reset the default but its better than nothing.
Cheers,
Sam
Hi samdthompson , I am just wondering if you have new updates on this one? I am having the same challenge where user can see own data + data of the people reporting to him/her however, upon log in the default view shows no selected filters and the visuals are either blank or zero. I was hoping that upon log in, the user automatically sees own data and filters are also automatically selected.
