Show Values of table based on current logged in user

[andtrds]

Hello

i have a table the has sample values like :

Value 1

Value 2

Value 3

i d like to create the following

when  a user logged in with email user1@demo.com to see only Value1 and selected automatically

i use RLS to see only the specific value but i cant make it to be selected automatically,user has to clik the Value 1

any help?

thank you

[v-shex-msft · Accepted solution]

Hi @andtrds,

You can create RLS based on username or userprincipalname function and filter on the table field that stored user account values. This filter will extract the current username as a condition to filter records.

Solved: RLS with UserName() - Microsoft Power BI Community

Regards,

Xiaoxin Sheng