Date slicer (slider) defaults to today

[akhaliq7]

I have a date slicer slider that when I open the report I want to be set for todays date. I also need to be able to change back the date slicer to the full range of dates using the slider. 

If i set it manually then it won't adjust to the current date tomorrow. If i set it as a filter then slider only shows the current date.

[truptis · Accepted solution]

Hi @akhaliq7 ,
Create a measure and put that as a filter.
Step 1: Creating a measure

Measure = if(max(tablename[date] <=today(),1,0)
Step 2: Click on your visual(slicer with the slider date), put a visual level filter where measure = 1

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards,
TruptiS

[Anonymous · Accepted solution]

Hi @akhaliq7,

The current power bi slicer does not support the default value.

I’d d like to suggest you add a calculated column to your table to compare the current date value with today function and return tag, then you can set a filter based on this column to filter today values.(the formula will auto-update when the system date changes)

Regards,

Xiaoxin Sheng

[truptis · Accepted solution]

Hi @akhaliq7 ,
Create a measure and put that as a filter.
Step 1: Creating a measure

Measure = if(max(tablename[date] <=today(),1,0)
Step 2: Click on your visual(slicer with the slider date), put a visual level filter where measure = 1

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards,
TruptiS