Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

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

5Rthx.png

 

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:

Wqk8X.png

if user1 logins:

Sp5pf.png

etc...

your assistance is much appreciated 



 
 

 

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

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

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

@Ritaf1983 

thank you very much for your help it is very clear you are the best 😀

Happy to assist 😊

Ritaf1983
Super User
Super User

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.