How to custom only end date in slicer date

[bmms]

Hello,

I have a calendar table which was created using the follow DAX:

CALENDAR = CALENDAR (DATE (2021,1, 1), DATE (2030,1, 1))

I would like to customize the end date of the slicer date, i.e. the end date is automatically the day we are.

For example, today is February 23rd and I would like the end date to be 02/23/2023 and tomorrow to be 02/24/2023.

But I can't do this, by default the slicer date assumes the date 01-01-2030.

Can you help me?

Best regards

[Padycosmos]

Please try the following:

 

[bmms]

Hello,

thanks for your feedback.

I can't use those style. One of the requirements sent to me is to use the standard (default) style, like this:

Best regards.

[johnt75 · Accepted solution]

Add a new column to your calendar table like

Today or before =
IF ( 'Calendar'[Date] <= TODAY (), 1 )

and you can then use that as a filter on the slicer

[bmms]

Hellow,

thanks for your feedback.

If I only want to use the date column, is there any solution?

Best regards?