Forum Discussion
Slicer Dynamic Default Value selection based on User Login
Hello ,
I need your Help Please
How can i configure PowerBI Slicer to Dynamically have Default Selected Values based on User Login. i have a table for users configured with LOB
LOB is assigned to a Slicer in my reports, i want based on user login the LOB Slicer to have default selected values as configured in the table.
example if user2 logins:
if user1 logins:
etc...
your assistance is much appreciated
Hi Anonymous , unfortunately, you can't make slicers that are with default choices based on a user's identification.
Here are some alternatives:
You can use RLS functionality
Users will get the report filtered according to what you define in their permissions without being able to choose other options.
You can read more here:https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
Allow the user to save filters in the service, this is also the default tool in Flablash. Every time, it'll enter a report filtered by last use.
For more information please see this tutorial :
https://www.youtube.com/watch?v=XF4kgPNpp70Let the user create personal bookmarks in the service, and then it'll save his choices.
For more information please see this tutorial :
https://www.youtube.com/watch?v=toRM2gcNc1Q&t=42s
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
3 Replies
Hi Anonymous , unfortunately, you can't make slicers that are with default choices based on a user's identification.
Here are some alternatives:
You can use RLS functionality
Users will get the report filtered according to what you define in their permissions without being able to choose other options.
You can read more here:https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
Allow the user to save filters in the service, this is also the default tool in Flablash. Every time, it'll enter a report filtered by last use.
For more information please see this tutorial :
https://www.youtube.com/watch?v=XF4kgPNpp70Let the user create personal bookmarks in the service, and then it'll save his choices.
For more information please see this tutorial :
https://www.youtube.com/watch?v=toRM2gcNc1Q&t=42s
If this post helps, then please consider Accept it as the solution to help the other members find it more quicklyRitaf1983
thank you very much for your help it is very clear you are the best 😀Happy to assist 😊