Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
I've created a PBI dashboard where it applies a dynamic RLS hierarchy - the user sees his/her own data and the data of the people within his team hierarchy. I was hoping that upon log in of the user, the page should automatically show his/her own data (i.e. user's name is automatically selected in the filters) then user can just select from the filters if he/she wants to see the data of other people within his team. Currently, upon log in, the default view of the page shows blanks in the visuals and the user still has to select from the filter name so the visuals update. Is there a way to make this work? Thank you in advance!
Hi @MOLIMAR123,
does the report have to be filtered to one person?
Otherwise I would recommend to leave the filter open, so that the team result (All) would then be displayed and the user can then filter on a specific person.
A dynamic preselection is not possible as far as I know.
@mwegener , ideally yes. so whoever logs in will automatically see his/her own data by default but still has the ability to select a name from the filters to see others' data. Is that not possible?
Hi , @MOLIMAR123
Good idea, but powerbi service does not support this feature currently.
For your needs, you can submit the idea to the idea forum.
If there are enough votes, the Product Team will take it into consideration when designing the next version in the future..
Best Regards,
Community Support Team _ Eason
@MOLIMAR123 , Power BI does not provide conditional filter preselection.
I would imagine that in each measure you check to see if it is filtering on a name and if not, then filter by DAX on the person logged in.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |