Relative Date Slicer - Yesterday?

[xuxxay88]

Hi,

I may be being a little silly, but I have a releative date slicer in a report, the user wants to view yesterdays figures. I would assume that you would select "Last 1 Day" but it appears that it shows as todays date. Would todays date not be "This - Day" and yesterday should be "Last 1 Day"? Maybe I am missing something.

Please see images below, the date I have taken this snips is 21/09/2021 (09/21/2021 for those on the other side of the pond)

Any suggestions, explanations, fixes etc are welcome 😁

In the meantime, they are clearing that filter and using the date filter on the filter pane but if there is something I can do with this relative filter then that would be greatly appreciated.

Thanks,

[Gawain]

I had the same problem, and now it's solved. Thank you

[moizsherwani]

It may be not the best solution but if you put a date silcer on a visual or a page you have the ability to remove "Today". See here

Regards,

Moiz

If this post helps, please "Accept" it as Solution to help other members find it.

[xuxxay88 · Accepted solution]

Ah you haven't quite given me the solution, but you've made me find the solution. Like I said initially, I was probably being a bit silly.

Under the format options for the slicer, there is this! I had it turned on rather than off.

Thanks!

[moizsherwani]

This is great. I learnt something new too 😀. All the best slicing and dicing away