dynamic end date as default in a between date slicer

[Ohana2410]

Hi everyone, 

is it possible to set a dynamic fixed end date as default in a between date slicer?

I would like the previous day of today to always be displayed as the default end date.

Just tested few things, but nothing seems to work. 

The below slicer must always show the same day like the upper slicer but in the previous year.

Any ideas?

Thanks in advance

[Anonymous · Accepted solution]

Hi @amitchandak ,

Thanks for the quick response.

Hi @Ohana2410 ,

I have created a simple sample, please refer to.

Measure = var _1= TODAY()-1
return
IF(MAX('Table'[Date])<=_1,1,BLANK())

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

[Ohana2410]

Thanks for your support, but unfortunately it doesn't work out for the below date slicer. 
Is it possible, that there isn't an option to solve this issue?

[amitchandak]

@Ohana2410 , As of now, we can set default value for between date slicer.

[Ohana2410]

Hey, I guess you meant "can't" don't you? 
kind rgds