Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Hi , @PBNikr
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
72 | |
69 | |
37 | |
29 | |
25 |
User | Count |
---|---|
91 | |
49 | |
44 | |
38 | |
37 |