Relative date based on slicer date

[abeirne]

Hi all, I am trying to show a 3 week snapshot based on the selected date that the user chooses. 



So for 1/1/2022, in the table i would like to only see 1/1/2022 to 1/21/2022 and the bookings associated with those dates. Both of the dates being used in the slicer and table are the same date column in the Calendar table. I tried ranking the dates but that appears to be ranking per row in the table. Thank you for the help. 

[FreemanZ · Accepted solution]

hi @abeirne 

you would

1) need an isolated table for the Date slicer

2) plot the table visual with a measure refering the slicer-selected value like this:

@Booking = 
VAR _date  = SELECTEDVALUE(datetbl[Date])
RETURN
CALCULATE(
    MAX(data[Booking]), 
    KEEPFILTERS(data[Date]>=_date &&data[Date]<=_date+13)
)

i worked like this: