set the date slicer so it always updates to today's date

[a_dika]

Hi,

on the Power BI dashboard, I have created a date table that includes dates starting from 1/1/2000 - 12/31/2050.

Here is the DAX that I have created:
DateTable =
VAR StartDate = DATE(2000, 1, 1) // Adjust the start date as needed
VAR EndDate = DATE(2050, 12, 31) // Adjust the end date as needed
RETURN
ADDCOLUMNS(
CALENDAR(StartDate, EndDate),
"DateAsInteger", FORMAT( [Date], "YYYYMMDD" ),
"Year", YEAR( [Date] ),
"MonthNumber", MONTH( [Date] ),
"MonthName", FORMAT ( [Date], "MMMM" ),
"Day", DAY ( [Date] ),
"CheckTodaysDate", IF([Date] = TODAY(), 1, 0) // New column to identify if the date is after today
)

I put "Date" into the slicer and selected the after option so that the date displayed is 1/1/2000. I filtered the "Date Slicer" using "CheckTodaysDate" and it will filter to the current date. But I can't select a date other than today's date.

Is there any way to make the date in the "Date Slicer" display today's date, but it will filter data from the first date to today's date and I can still select dates other than today's date?

[Idrissshatila]

Hello 

Leaving this here as it may help people searching
https://youtu.be/kVcStgZhnuw?si=__o61_izYQkikbn8

[cath1ynn · Accepted solution]

Pretty easy actually. You just change your "CheckTodaysDate" to the below and you should be able to select dates other than today and the To in the Date filter should always show today.

IF([Date] <= TODAY(), 1, 0)

 Before applying filter:

After applying filter:

[Ritaf1983]

Hi @a_dika 

Please refer to my solution in the linked discussion:
https://community.fabric.microsoft.com/t5/Desktop/PowerBI-Date-slicer-not-extending-to-the-latest-da...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly