Multiple copies of visual, each filtered by date relative to slicer

[northshorehiker]

Hi there--

I'm looking at using the "at Timeline" visual from Pragmatic Works to show eight days worth of status logs. I'd like to select a single date in a slicer and have the top visual display data for the selected date, visual #2 to display data for one day after the selected date, visual #3 for two days after the selected date and so on... 

I managed to create a dynamic column which contains the number of days between that row's date and the date selected in the slicer, but using that column as a visual-level filter doesn't seem to override the existing filter to show all start / end dates. (These columns are used in the visual, and so can't be removed from the visual-level filters.)

Is there any way to make this work?

[v-frfei-msft · Accepted solution]

Hi @northshorehiker ,

As we know, the data in calculated column is not dynamic based on the slicer value. So it is hard to achieve your goal. Here I create a sample for your reference as a workaround.

1. Cretae a slicer calculated table.

Slicer = CALENDARAUTO()

2. Create a measure as below and make the visual filtered by the measure.

Measure = var _sele = SELECTEDVALUE('Slicer'[Date])
var _date1 = MAX('Table1'[Date])
return
IF(_date1>=_sele && _date1<=(_sele+7),1,0)

Regards,

Frank