How do I set a defualt date for a date slicer

[ThomasWeppler]

Hi Power BI community

How do I set a default date for a date slicer?

I want my date slicer to always start at the first date of the year.
I can ofcause choose the date 01/01/2024 but than I will have to change the date and upload the repport again every year, so I want to know if there is another way to do it. 🙂

[bhanu_gautam · Accepted solution]

@ThomasWeppler , Currently there is no direct way but you can try using bookmarks

In your date table, create a calculated column that identifies the first date of the year for each date. You can use the following DAX formula:
DAX
FirstDateOfYear = DATE(YEAR([Date]), 1, 1)
Create a Measure for the Default Date:
Create a measure that calculates the first date of the current year. This measure will dynamically update each year:
DefaultDate = DATE(YEAR(TODAY()), 1, 1)

Set the Default Date in the Slicer:

Add the date field to the slicer.
Use the measure DefaultDate to set the slicer's default value.

Instead of a standard date slicer, use a relative date slicer.
Set the relative date slicer to show dates in the "This Year" range. This will automatically adjust to the current year without needing manual updates.
Using Bookmarks:

Set the slicer to the desired default date (e.g., 01/01/2024).
Create a bookmark with this slicer setting.
Use this bookmark to reset the slicer to the default date whenever needed.