Forum Discussion

erikm's avatar
erikm
Frequent Visitor
5 years ago

Set fixed date for date slicer

I am designing a report that contains a date slicer. Would it be possible to have the from-date automatically set, based on the to-date? For example, when the user selects 06/29/2021 as the end date, I would like to have 01/01/2020 automatically set as the start date, without the ability for the user to change that.

 

The logic would be, that the from-date is always January 1st of the year before the selected end-date.

 

Thank you!

Need Help

2 Replies

  • Kumail's avatar
    Kumail
    Impactful Individual
    5 years ago

    Hello erikm 

     

    You can do something like this

    Measure as filter = 
VAR MonthsToLookBack = 10
VAR DataTableDate = MIN('Data Table'[Date])
VAR DateTableDate = MIN('Dates'[Date])
VAR DateAddAlternative = EDATE(DateTableDate,-MonthsToLookBack)
RETURN
    IF(
        (DataTableDate < DateTableDate)  && 
        (DataTableDate > DateAddAlternative)  ,
        -- FLAG IF TRUE --
        1
        )

    If you could send sample .pbix that demonstrate what you are looking to get. It would really help providing you a quick implemented solution.

     

    Hope this helps

     

    Regards
    Kumail Raza

     

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    Hi erikm ,

     

    Can this meet your requirements?

    StartDate =
VAR SelectedDate_ =
    SELECTEDVALUE ( Dates[Date] )
VAR StartDate_ =
    DATE ( YEAR ( SelectedDate_ ) - 1, 1, 1 )
RETURN
    StartDate_

    Measure = 
IF (
    MAX ( 'Data Table'[Date] ) >= [StartDate]
        && MAX ( 'Data Table'[Date] ) <= SELECTEDVALUE ( Dates[Date] ),
    1
)

     

     

    Best Regards,

    Icey

     

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