Filtering data through yeterday

[JSmart913]

I have a report where I want to filter the dat up through yesterday automatically without having to have a slicer and changing the day on the slicer every morning.  Is this possible?  Basically I would want to see number of sales and number of expected sales for the month up through yesterday

[Greg_Deckler]

@JSmart913 Several ways to do this. One would be to add this column to your data and then set a page or report level filter to filter for 1:

Column = IF( [Date] < TODAY(), 1, 0 )

This assumes that the data is refreshed every morning for example.

[JSmart913]

Thank you!  Is there a way to do it on the visual level instead of adding to the dataset?