I don't think you can do it with filter functions.
Only similar result is done by parameter , but as you know, you cannot get the latest day dynamic update.
Other option is
- If it's only "1" day, you can use "Top 1" filter as default (Not bring 3), if you use top 3, use selection of single date only brings single day.
- Duplicate whole data three times to get three days bucket as one set. => your data is already big and I am not sure it's realistic or not.
- version 2018.3 => we have "Set Actions" which have more flexibility as to filtering without filtering underlying data.
As Shin mentioned, you can't do it via filter, the only way to achieve it is by parameters.
Below is the sample of using two parameters, one for default or custom selection, and the other is the date picker when user select custom.
And when you save or publish your workbook, set the default/custom parameter as default so that every time when user open the report, it always shows the default setting.
Make sure, any of the filter you add, please right click and select add to context(then it will grey out in the filter pane).
A workbook attached for your reference.
ingestion mock_v10.3.twbx 8.1 MB
This is amazing, it worked - thanks