Would you be able to attach a sample workbook with this data? There are a few ways you could go about this depending on how your data is set up. One of them is talked about in this thread: How to use Relative date and Date range quick filters together in a Dashboard?
Let me know if that helped. If not, hopefully I can take a look at the data and see what your working with.
Can you please share the sample data/workbook.
From looking at your solution, I'd have to update the filters daily to change the dates.
Is there a way to do this automatically so that it always shows 'yesterday and today' regardless of the date?
Simply put [Datetime Shifted] field to filter as relative date with last two days??
Need to set continuous to have relative date feature.