Default Manager Slicer using USERPRINCIPALNAME()

[Anonymous]

Hi All,

I have a Manager Slicer in my report, and I want each manager to see their own data by default when they log in to Power BI Service. However, they should also have the option to view others' data if needed. I have the Manager Name and Manager Email ID in the same table.

[Anonymous]

Hi @Anonymous ,
Thanks for rajendraongole1 reply.
According to your description, your goal is to make the default view of the administrator be the administrator's data, but also see other people's data. So, you can try to use the App function in power bi service, you can set up the administrator page and the general user page, for different roles you can give different page permissions.
Publish an app in Power BI - Power BI | Microsoft Learn

Best regards,
Albert He

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

[Anonymous]

Hi @rajendraongole1 ,
Actually I dont want to Apply RLS the requiredment is 
"I have multiple visuals and multiple slicers in my Power BI report. One of the slicers is for managers, and I also have managers' emails. What I want is for the manager to see their data filtered by default when viewing the report in Power BI Service, but also have the option to choose to see others' data."

[rajendraongole1]

Hi @Anonymous - Please refer the below link to achieve your requirement

Dynamic Row-Level Security for Manager Level in Power BI? | RLS In Power BI Ep4 | BI Consulting Pro (youtube.com)

Hope it helps.