RLS Security default slicer selection

Hi Anonymous ,

Currently, we cannot set default value for slicer in power bi desktop. We can create a new calculated column to work around.

Please check following steps as below, this might help you:

1.    Create a calculated column:

       Column = IF( 'Table'[product] = "product1" || 'Table'[product] = "product4","default",'Table'[product])

2.    Create a slicer by product and select “default”

3.    Result would be shown as below when we view as different roles:

Pbix as attached, hopefully works for you.

Community Support Team _ Jay Wang

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

HI Anonymous 

MY requirement if different than above. Can you please help on this.

User                     Product
User1                   Product 1
User1                   Product 2
User1                   Product 3
User2                   Product 2

I want, "Product 1" should be default selection when User1 logged in and "Product 2" default selection for when User2 logged in.