Filter a dropdown depending on who's connected

[XavierC2]

Hi guys,

I would like to filter my reports depending on who's connected to the app.

To proceed I have a drop down list in which a value is selected when one or another is connected.

It works very well when I have only one selection related to the connected person. But when I need 2 selection to be checked, I don't kown how to do that.

I need to see 2 or more choice when a specific user is connected, like that 

Is it possible?

Thanks

[XavierC2]

Thank you!

[v-binbinyu-msft · Accepted solution]

Hi @XavierC2 ,

Please try below steps:
1. below is my test table

Table:

2. create a role

CONTAINSSTRING([Email],USERPRINCIPALNAME())

3. add a slicer with table field

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

You are describing RLS (Row Level Security) functionality.