Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
kasen
Regular Visitor

PowerBI RLS on slicer in dashboard

kasen_0-1686476488242.png

 

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:

 

kasen_1-1686476533074.png

 

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:

kasen_2-1686476603285.png

After applying RLS:

kasen_3-1686476639631.png

 

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:

 

kasen_4-1686476682679.png

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!

1 REPLY 1
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors