Autometic set Date-Splicer from date mm.dd.yyyy to today

[WKusnezow]

Hello everyone 🙂

as you can see in the screenshot I have a simple date slicer. It is working great. I am struggeling to set a dynamic value for the max value. Now the 02.27.2025 (in the screenshot the date format is in for germany) is selected as the max value. Tommorow it will be the same, but I want it to automatically change to 02.28.2025 and so on. Am I missing some setting or is it not possible?

[divyed]

Hello @WKusnezow ,

There are coupls of things you can do :

1. Use a Relative Date Slicer

   Steps :

• Add a Date slicer to your report.
• Click the slicer → Change slicer type to Relative Date.
• Set it to "In the last" X days, weeks, months, or years based on your needs.
• This will automatically adjust the end date to today.

2. Create a Dynamic Date Column :

   If you need a standard slicer instead, create a calculated column that flags dates up to today.

    IsValidDate =
           IF ( 'Date'[Date] <= TODAY (), 1, 0 )
   Steps :

     => Add this column to your Date table.

     => Use it as a filter in your slicer: Set the filter pane to IsValidDate = 1

3. Use a Measure for Dynamic Filtering

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

Add this measure to a visual’s filter pane

Set it to show values where FilterDate = 1

This approach ensures only dates up to today are considered dynamically

I hope this helps.

Did I answer your query ? Mark this as solution if this helps, Kudos are appreciated.

Warm Regards,

Neeraj

[Rupak_bi]

Hi @WKusnezow ,

The slicer should automatically update everyday if new date is updated everyday in the dataset column refered in the slicer.  please share somemore informations to better understand the issue.

[WKusnezow]

Hello Rupak,

my slicer got the field "Date" form my table "Calender" which is from 01.01.2025 till 12.31.2030.
All dates from the table are selectable in my slicer. But my problem is that I cant set up a dynamic defaul value for the "from date" and "to date". Once I set the "to date" for example to 03.01.2025 and publish it, it always will be the starting value when you open the report. I need to change it manually everytime I publish or the users have to change it each time they open the report to the current date.

Tell me what infos would help you to understand the problem better 🙂

[mdaatifraza5556]

Hii @WKusnezow 

Please follow the above approach.
You will get your sollution.
If you find any issue while doing it let me know.

[mdaatifraza5556]

Hii, @WKusnezow 
Please follow the steps:

1. 
Create measure
-----------------------

preselected_default =

    VAR _today = TODAY()

    VAR min_date = MIN('Date'[Date])

    VAR selected = SELECTEDVALUE('Date'[Date])

RETURN

    selected <= _today && selected >= min_date

2. 

Create table 
-------------------

_PreselectedSlicer = DATATABLE(

    "IsDirtySlicer1", BOOLEAN,

    {

        {FALSE()},

        {FALSE()},

        {TRUE()},

        {TRUE()}

    }

)

3.
Import pre selected slicer


4.
Drage and drop in it

4. Don't remove your previous slicer keep them as it is.

You will get your solution

5. Then hide the preselected slicer



If you find my approach then accept it.