Create a calculated field
[order date] <today(), place it in filter and select true so that your dashboard will show only data up to yesterday
Hope this helps kindly mark this answer as correct/helpful so that it will help others
Try with this
create calculated field and put this formula
Date column < Today()
What ever you have Date column for example "Order Date"
[Order Date] < Today()
Drag this calculated field into the filter and select True.
Yeah, but the thing is that i create a Calendar with a parameter,
And when I use it, all the dates are available... I need a type of calendar filter but when the user chooses a date he only has the possibility to choose a date within the two years of history and yesterday, I don't know whether to use another type of filter that is not a parameter.
Same response, im using a date parameter as filter, so all the dates are available.. i need to restrict the dates in the parameter so the user only has the possibility to choose a date within the two years of history and yesterday,
If I use a continuous date filter I don't have the possibility to see the dates as a calendar..