Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
homboy27
Helper III
Helper III

Filtering on POWERBI username

I am trying to  filter on Power BI report baased on Manager email Id. I want them to see Users sales of who they are manager of. Is there a way of filtering it?

Manager Email addressManagerUserSales
User A IdUser AUser A5000
User A IdUser AUser B5000
User A IdUser AUser C5000
User A IdUser AUser D5000
User B IdUser BUser E5000
User B IdUser BUser F5000
User B IdUser BUser G5000
    
2 REPLIES 2
audreygerred
Super User
Super User

Hello! You can achieve this with dynamic row level security using USERPRINCIPALNAME() DAX function. That way, when your managers login they see their users' info, but not the users that are assigned to a different manager: Dynamic Row Level Security with Power BI Made Simple - RADACAD





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Thanks Ive tried the row level security, but I only see my information and not everything that is tagged under me. What can I be doing wrong?

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.