Forum Discussion
PBNikr
6 years agoHelper 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
- v-easonf-msftCommunity Support
Hi , PBNikr
Can you explain your question with screenshots of your visuals, which helps us understand your problem.Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Best Regards,
Community Support Team _ Eason