Hi Everyone,
Below is the model of my project which consist of 2 RLS table and those RLS tables are filtering Fact table based on the product_id and customer_id.
Overhere, my issue is i'm unable to filter the dimension table as per the user.
For eg: I have given access to person A for prdocut XYZ then it is perfectly filtering in fact table but dimension tables data is not getting filtered for person A. It's still showing the whole data. Although i selected cross filter direction as "Both".
Kindly let me know if you encounter such issue and able to find some solution. Please find the attached screenshot of data model for your reference.
Best Regards,
Abhijit
Helpful resources
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
