Forum Discussion

SudhanshuD4512's avatar
SudhanshuD4512
Frequent Visitor
9 months ago
Solved

Default Date for date slicer

I'm working with a date range slicer in Power BI that is set to "Between" mode to allow users to select both a start and end date. I have a fact table from which i want to pull the date of sales or...
  • 123abc's avatar
    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!

  • divyed's avatar
    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,