PowerBI RLS on slicer in dashboard

[kasen]

Hello everyone,

The screenshot above is my data model for PowerBI dashboard. I already set the "Cross filter direction" between City lookup and Restaurant Inspection Data to "Both".

I applied RLS on the Inspector Lookup table as shown in the screenshot below:

When I tried to test the RLS by using "View as" in PowerBI, most of the DAX measures and visuals work well. However, I realized that the filter from RLS did not apply on the City Lookup table even thought I already set the cross filter direction to "Both". Below are the 2 screenshots before I applied RLS and after I applied RLS:

Before applying RLS:

After applying RLS:

As you can see in the screenshots above, after I applied the RLS, the bar chart and column chart at the left hand side were filtered, but City slicer and table at the right hand side still remain the same. What I need to do is select the Inspector Name in the slicer, then the table and city slicer only reflected accordingly as shown in the screenshot below:

May I know is there any way that I can avoid this situation? By right, if I want to apply RLS, there is no Inspector Name slicer in my dashboard since each inspector is only able to see his own data so the inspector slicer is useless to put in the dashboard. I want the City table are able to affected by the RLS as well, any help or advise will be greatly appreciated!

[lbendlin]

What I need to do is select the Inspector Name in the slicer, then the table and city slicer only reflected accordingly as shown in the screenshot below:

That is not really necessary.  Let the data model do the work for you.  Avoid having search directions pointing back into dimensions. They will filter automatically in the visual as soon as you add fact data.

If you want the City to affect the RLS then you need to apply RLS rules in the City table.