Forum Discussion
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 address | Manager | User | Sales |
| User A Id | User A | User A | 5000 |
| User A Id | User A | User B | 5000 |
| User A Id | User A | User C | 5000 |
| User A Id | User A | User D | 5000 |
| User B Id | User B | User E | 5000 |
| User B Id | User B | User F | 5000 |
| User B Id | User B | User G | 5000 |
2 Replies
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
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?
