Forum Discussion

selected_'s avatar
selected_
Icon for Helper IV rankHelper IV
3 years ago

Slicer don't change according to RLS

I have build a report with 5 different slicers that coming from 5 DIM tables, but when vewing in specific role then the slicers don't appear to adjust according to that role. Instead, all options rem...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi selected_ ,

If I understand correctly, you apply RLS on the table(s) and create some slicers with the fields from dimension tables. But the slicer option display not effected by RLS. Am I right? According to this official documentation, RLS rely on well-designed relationships to ensure RLS filters propagate to other model tables. RLS filters only propagate through active relationships. So, avoid using the LOOKUPVALUE DAX function when model relationships could achieve the same result. Could you please provide the following info for the further investigation?

  • How did you set the RLS? And in which table(s) set RLS? Dynamic RLS or static RLS?
  • How did you create the relationships among the tables(fact and dimension tables)?

Best Regards