cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Default selected slicer values based on user table

Hi!

 

I am working on a report where the slicers must have default selected values based on a user table. I have previously only worked with default values based on roles/security and not a specific table. Persistant filters would have been a good workaround but I believe this is only available for the Power BI Service and we are using Power BI Report Server.

 

For example: User A can see options 1, 2 and 3 in the slicer but has option 2 as the default value according to the table. Option 2 is pre-selected when he/she opens the report.

 

Is there a straightforward way of making this connection in SSAS and implementing it in Power BI? I am using a tabular model with direct query mode and Report Server on prem.

 

Thanks!

 

1 REPLY 1
Highlighted
Microsoft
Microsoft

Re: Default selected slicer values based on user table

Hi , @PBNikr 

Can you explain your question with screenshots of your visuals, which helps us understand your problem. 
 
Best Regards,
Community Support Team _ Eason

 
 

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors