cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Getting 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?

Screenshot 2020-10-30 104145.png

1 ACCEPTED SOLUTION

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 chosenbefore RLS the slicer has been chosenwhen using RLS, slicer shows previous value by defaultwhen using RLS, slicer shows previous value by defaultclick the swim manuallyclick 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.

View solution in original post

3 REPLIES 3
Memorable Member
Memorable Member

@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

RLS1.png

Before RLS AppliedRLS2.png

After RLS applied
RLS3.png
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!!👍



I'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.

 

Screenshot 2020-10-30 112425.png

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 chosenbefore RLS the slicer has been chosenwhen using RLS, slicer shows previous value by defaultwhen using RLS, slicer shows previous value by defaultclick the swim manuallyclick 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.

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors