Date Slicer - default selection without filtering

[dpalouktsis]

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 (DATE(2024,1,1), TODAY() + 360),
"Year", YEAR([Date]),
"Month", MONTH([Date]),
"MonthName", FORMAT([Date], "MMMM"),
"YearMonth", FORMAT([Date], "YYYY-MM"),
"Day", DAY([Date]),
"Weekday", WEEKDAY([Date], 2)
)

This table is connected to my fact table via the [Date] column.

I have a slicer (style: between) on a report page using Date_Departure[Date]. I want to prefilter the slicer to start from TODAY() (i.e., select today's date and onward), without filtering the data - meaning that also past dates are available if I click on the slicer.

I'm open to any workaround or even payed visuals. I've tried mutiple stuff but without any result.

Thank you all,
Dimitris

[v-tsaipranay · Accepted solution]

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 Community. This 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.

[dpalouktsis]

Thank you @v-tsaipranay and @miTutorials for the valuable input.

Best Regards,
Dimitris

[miTutorials]

Take a look at this video and let me know if this helps!

Default dynamic Date Slicer and also custom select Dates in PowerBI | MiTutorials

[dpalouktsis]

Hello,

I carefully reviewed the video, however I doubt that will work on my case, as we also use LY metrics with SAMEPERIODLASTYEAR functions at our PBI. Would there be any workaround about this?

Thank you,
Dimitris