Set the default end date to today in date range slicer

[dgdgdg122db]

hi there,

 I want to show the reporting date always from the date 1/1/2020 to "Today" by default. how can I set the end date to today by default?

[v-deddai1-msft · Accepted solution]

Hi @dgdgdg122db ,

You can add a visual level filter on the slicer:

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

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

Best Regards,

Dedmon Dai