Forum Discussion
RLS with Single Select Slicer
Hi kewaynes ,
If you use single slicer, you will need to select the correct one manually and then the "Average" will be filtered.
According to your statement, I think you just need to create a dynamic RLS instead of using slicer.
You may refer to below blog to learn more details.
For reference:
Dynamic Row Level Security with Power BI Made Simple - RADACAD
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I don't see where I have an attachment option. But all it is, is a single table that looks like this:
That has RLS applied like this:
And then of course the single select slicer:
Hi kewaynes ,
If you use single slicer, you will need to select the correct one manually and then the "Average" will be filtered.
According to your statement, I think you just need to create a dynamic RLS instead of using slicer.
You may refer to below blog to learn more details.
For reference:
Dynamic Row Level Security with Power BI Made Simple - RADACAD
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I don't think this will work. RLS is enabled. However, the default selection for the single select slicer still appears when the report loads, whether it's part of the RLS filtered dataset or not.
For example, if the user is French but the English is the default selection when I publishe the report, the English will appear even though it's not really a 'valid' selection. The user will need to change to French in order for the visuals to populate.