Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
tiavinag
New Member

Default value of a date range slicer

Good morning all,

Is there a way to set default start and end value of a date range slicer to the "1st Jan to of current year" to "today" when the "clear all filters" button is clicked. 

I have the date range slicer :

C1.png

And the calendar table:

C2.png


Thank you for your help.

2 REPLIES 2
tiavinag
New Member

Good morning, I created my Calendar table in Power Query. Also, my date range slicer is synchronized in multiple pages.

Capture d'écran 2024-08-14 072256.png

qqqqqwwwweeerrr
Super User
Super User

Hi @tiavinag 

 

I am not sure about your data model since you have not shared your data i am assuming you have Calender table if not you can create something like this 

DateTable =
CALENDAR(MIN('Calender'[Date]), MAX('Calender'[Date]))
MonthDay = FORMAT('DateTable'[Date], "MM-DD")
Year = YEAR('DateTable'[Date]) and these two column if required

this calculated column you need to create and add into your filter pane 
IsCurrentYear =
IF(
   
    'DateTable'[Date] <= TODAY(),
    TRUE(),
    FALSE()
)qqqqqwwwweeerrr_0-1723553978554.png

 

Check here avery thing is true till date now you data is filter for min date to till today one you apply this custom column in filter column
Now, for default value from 1st Jan, you manually select this 1Jan in filter create bookmark and apply that action on clear all filter (Note you can deselect all the filter and then update the bookmark so the action will be same clear all filter)
qqqqqwwwweeerrr_1-1723554178289.png

 

I under stand you might require this piece dynamic but i have to check even it is possible 

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

Regards


 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.