Forum Discussion
Helper IIGetting filters to change with RLS Roles on the actual power bi page
Hi All,
I'm trying to do some RLS for my report and i'd like it to change the filter on the page as well so that the viewer knows what is being filtered. For example: I created a role for my swim coach so that they could only see data from my swim team but the filter displayed on the page shows women's volleyball. Is there any way to sync the filter on a report page to the role level?
Hi drivas771994 ,
RLS looks like a filter in power bi, when you create a role like '[Type] = "Swim"', it will show the data about swim field. However, it is based on that you have not filtered slicers. For example, before enabling RLS, you have filtered the slicer equals 'Volleyball', after enabling RLS, the slicer will keep the 'swim' and 'volletball' at the same time. You need to click the 'swim' in the slicer to eliminate other fields in the slicer.
before RLS the slicer has been chosenwhen using RLS, slicer shows previous value by defaultclick the swim manually
As far as I know, to avoid this phenomenon, not select the slicer before using RLS is a better way.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
drivas771994 Yes that is what RLS does you can follow the below screeshot
Since you have already created a role for swim coach you will have to add another condition like below
Before RLS Applied
After RLS applied
I hope this is what you were looking for...Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos, Press the thumbs up button!!👍
drivas771994I'm confused as to what else I would ask it to filter since I set the rule for it to filter swim. I'm not looking for it to filter anything else for RLS. I just want it to display on the filter I circled in red on the report page.
- v-yingjl
Community Support
Hi drivas771994 ,
RLS looks like a filter in power bi, when you create a role like '[Type] = "Swim"', it will show the data about swim field. However, it is based on that you have not filtered slicers. For example, before enabling RLS, you have filtered the slicer equals 'Volleyball', after enabling RLS, the slicer will keep the 'swim' and 'volletball' at the same time. You need to click the 'swim' in the slicer to eliminate other fields in the slicer.
before RLS the slicer has been chosenwhen using RLS, slicer shows previous value by defaultclick the swim manually
As far as I know, to avoid this phenomenon, not select the slicer before using RLS is a better way.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
