topic Autometic set Date-Splicer from date mm.dd.yyyy to today in DAX Commands and Tips

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

WKusnezow — Thu, 27 Feb 2025 10:00:51 GMT

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?

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

mdaatifraza5556 — Thu, 27 Feb 2025 10:41:09 GMT

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()},

{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.

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

Rupak_bi — Thu, 27 Feb 2025 11:10:05 GMT

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.

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

WKusnezow — Mon, 03 Mar 2025 12:15:41 GMT

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 🙂

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

mdaatifraza5556 — Tue, 04 Mar 2025 03:58:37 GMT

Hii WKusnezow

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

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

divyed — Tue, 04 Mar 2025 08:01:54 GMT

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