Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
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=XF4kgPNpp70
Let 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
@Ritaf1983
thank you very much for your help it is very clear you are the best 😀
Happy to assist 😊
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=XF4kgPNpp70
Let 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
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
53 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |