Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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 |
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
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?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |