The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi all,
I have a published power bi report that looks at data from 2023-2025, with a year slicer that has the option for multi-select. The default page (the one I saved on and pops up when people open my report for the first time) has the slicer set to just show 2025 values. However, if someone opens my reports and selects both 2024 and 2025, for example, and then closes the report and reopens it, the report retains their selection for both 2024 and 2025 instead of going back to the default of just 2025. I would like this not to be the case ie. when other people open/close my report I want it to keep bringing them back to the default view regardless of the slicers/drill downs they have applied in past sessions.
Solved! Go to Solution.
Hi, I actually just figured this out! Turns out it is as simple as a setting. If you navigate to your reports location, hit the three dots, go to setting, and turn on the setting "Persistent Filters," that should do the trick.
Hello @Pranavrcn ,
The question has been asked before. Therefore, I shared the community link:
https://community.fabric.microsoft.com/t5/Service/Date-Slicer-Default-setting/m-p/4179893
Kind Regards,
Gökberk Uzuntaş
📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!
🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |
Hi, I actually just figured this out! Turns out it is as simple as a setting. If you navigate to your reports location, hit the three dots, go to setting, and turn on the setting "Persistent Filters," that should do the trick.
I would like this not to be the case ie. when other people open/close my report I want it to keep bringing them back to the default view regardless of the slicers/drill downs they have applied in past sessions.
While it is technically possible to prevent users from saving their filter choices it is considered bad practice as it will result in a frustrating user experience. Try not to do that.