Forum Discussion

rfontaine's avatar
rfontaine
Advocate I
6 years ago

Relative Date Filter for Yesterday Not Working

I've read through the posts on relative date filtering that I could find, but I'm still stuck on how to get this to work.  I am trying to set a filter on a Date slicer that will always show yesterday...
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, rfontaine 

 

Based on my research, It is the issue about selectable values and selected values of a slicer. Actually, slicer selectable values change with context, but selected values can't change automatically. When it comes to 'Today', the selected date of yesterday will still exists because it can't change automatically. However, the selectable date is changed as today and it appears in the list. I think it is a normal phenomenon.

 

Best Regards

Allan

 

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

rfontaine's avatar
rfontaine
Advocate I
6 years ago

v-alq-msft Allan, thanks for the reply.  That does seem to be what's happening in my situation.  I changed the filter to page-level instead and it actually seems to be working.  This morning (March 27) when I checked the report the date was set to March 26.  So, at least I have a workaround by not using the visual slicer.