Forum Discussion

Ohana2410's avatar
Ohana2410
Frequent Visitor
2 years ago
Solved

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

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Ohana2410
      Frequent Visitor
      2 years ago

      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?

    • Ohana2410's avatar
      Ohana2410
      Frequent Visitor
      2 years ago

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