Forum Discussion

dpalouktsis's avatar
dpalouktsis
New Member
1 year ago
Solved

Date Slicer - default selection without filtering

Dear friends, I have a request that is probably undoable but this post is my last resort, just in case someone have faced/fixed this issue before. Date_Departure = ADDCOLUMNS ( CALENDAR (...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi dpalouktsis ,

    Thank you for reaching out to the Microsoft Fabric Community and thank you miTutorials for sharing the helpful video link.

     

    To clarify, Power BI currently does not allow a Between-style date slicer to visually default from TODAY() to a future date without applying that filter to the report. The method in the video sets the slicer to start from today, but it still filters out past data immediately.

    If you want the slicer to look pre-selected from today onward but still show all data by default, here are two possible workarounds:

    1. Use a disconnected date table with bookmarks or custom measures to create a similar effect.
    2. Try custom slicer visuals (such as Smart Filter Pro) that let you pre-select visuals without immediately applying a filter.

    Since this feature isn’t currently available, you might also consider posting your scenario on the Fabric Ideas - Microsoft Fabric CommunityThis is where the product team looks for user feedback, and the more upvotes a suggestion gets, the more likely it is to be added in future updates. 

     

    Hope this helps. Please reach out for further assistance.

    If this post helps, then please consider to Accept as the solution to help the other members find it more quickly and a kudos would be appreciated.

     

    Thank you.