Slicer value

[VK7]

In my report, In Slicer (single select) we've values like US, Europe, AISA. While publishing the report the selction of the report is "US".
But after sharing to users. Some users will have only access for Europe (RLS).
So for them while opening the report it is showing black data with slicer selection "US". any workaround to have slicer to be dynamic 

[Ritaf1983 · Accepted solution]

Hi @VK7 
Unfortunately no, only to use a multiple selections slicer.

 If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Idrissshatila · Accepted solution]

Hello @VK7 ,

then publish it without selecting any values, in order to maintain the data for every RLS.

[PijushRoy · Accepted solution]

Hi @VK7 

When you are using RLS for US, Europe, AISA, please don't use single select.
In single select slicer, by default 1st value selected or US manually selected and it will create same problem you facing.
Please turn off single select.
Use dynamic RLS https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[Idrissshatila · Accepted solution]

Hello @VK7 ,

then publish it without selecting any values, in order to maintain the data for every RLS.

[Ritaf1983 · Accepted solution]

Hi @VK7 
Unfortunately no, only to use a multiple selections slicer.

 If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly