Date slicer with dates and having default today being selected

[dennydavis]

I have a date slicer.

I have a range of dates being shown within it.

Is it possible to show today's date within the calendar slicer as a default value selected? I tried creating a measure with selected value, but I was not able to drag and use it within the date slicer. Is this possible in any ways. Can someone provide me with a sample if possible. Thanks in advance.

[Anonymous · Accepted solution]

Hi @dennydavis ,

You can create a calculated column to judge if the “current” date is today or not, then applied this column into report-level filter and filter the value with "Yes". You can refer this video for all details.

IsToday = IF ( Table[Date] = TODAY (), "Yes", "No" )

Best Regards

Rena

[ibarrau]

Hi. You can't select a relative date in range slicer as default, that's why the relative date slicer is for. You can add another slicer with the relative "This Day" in order to filter by today. If they want to use the range you must first erase the relative filter.

I'm sorry but that's the only way you can do it for now.

Regards,