Forum Discussion
Default Date for date slicer
- 9 months ago
Hi,
Yor can do this in Power BI but but not directly using the slicer default settings, because Power BI still does not support dynamic default values for “Between” slicers.
You can try below step to trublshoot this issue:
Set your date slicer to Between mode.
Manually set the slicer to:
Start of current month
Last data refresh date
Go to View → Bookmarks
Create a bookmark:
Name it: Default Date Range
Under bookmark settings:
✔ Data
✔ Display
✔ Current page
Add a button labeled "Reset Date Range"
Assign the bookmark to the button.
when the report open slicer stays at bookmarks defaulf unless the previouly cahnged slier by you and pwoer bi saved it for session. You can adust the slicer whenever needed.
They can always click Reset Date Range to return to “Start of month → Last refresh date”.
OR
Below is the sloved community solution please try it:
Setting a default value for 'between' date slicer
Solved: Setting a default value for 'between' date slicer - Microsoft Fabric Community
I hope this helps!
If you found this answer helpful:Mark it as the solution to help others find it faster.
Give it a kudo to show your appreciation!
Thank you for being an awesome community member! - 9 months ago
Hello SudhanshuD4512 ,
you can use bookmarks to achieve the same.
1. Create a bookmark with default values ( I think you have already or can create using suggested approach)
2. Create another bookmark for custom selection ( to choose from and to ).
3. Add an information button to provide user information ( optional)
This will give your user control of using default or custom dates.
I hope this helps.
Did I answer your query ? Mark this as solution if this helps.
Warm Regards,
Hello SudhanshuD4512 ,
you can use bookmarks to achieve the same.
1. Create a bookmark with default values ( I think you have already or can create using suggested approach)
2. Create another bookmark for custom selection ( to choose from and to ).
3. Add an information button to provide user information ( optional)
This will give your user control of using default or custom dates.
I hope this helps.
Did I answer your query ? Mark this as solution if this helps.
Warm Regards,