Forum Discussion
dynamic end date as default in a between date slicer
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
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
Super User
Ohana2410 , As of now, we can set default value for between date slicer.
Hey, I guess you meant "can't" don't you?
kind rgds
