cancel
Showing results for
Did you mean:
Responsive Resident

## Date slicer (slider) defaults to today

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.

2 ACCEPTED SOLUTIONS
Super User

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

Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
2 REPLIES 2
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Super User

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