dynamic date filter

[67nmark]

Hello,

This is a repost - the earlier post had incorrectly picked up the url to the sample.
 

I was watching the tips and tricks video from Tech Ed (https://www.youtube.com/watch?v=LrSV7d28EAA) where the presenter has used a measure to create a dynamic date slicer. The measure is then used as a filter on any visuals where you want the slicer to filter the dates.

I have tried to replicate the date slicer on some sample data ( https://1drv.ms/u/s!AtIcMmSmmXe9gap5KwuKiewCVxUEvg ) and it doesn't work for me - so if anyone could give me a nudge in the right direction then it would be appreciated.

Cheers and thanks in advance,

Mark

[v-qiuyu-msft · Accepted solution]

Hi @67nmark,

You can change the Cross filter direction between the dates table and Sales table as Both, then the measure will be working. 

Best Regards,
Qiuyun Yu 

[67nmark]

Thanks very much. That's working great.