Forum Discussion

VK7's avatar
VK7
Frequent Visitor
2 years ago
Solved

Slicer value

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 


Tips and Tricks
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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's avatar
    Idrissshatila
    2 years ago

    Hello VK7 ,

     

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

  • PijushRoy's avatar
    PijushRoy
    2 years ago

    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

3 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    2 years ago

    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's avatar
    Idrissshatila
    Super User
    2 years ago

    Hello VK7 ,

     

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

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    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