Auto Update Start Date in Slicer

[RobertReeves]

I have a report that has information for services scheduled. The data pull has data starting from 2020 through future dates. When the data set refreshes, is there a way to have the start date in the slicer automatically update to the previous days date?

Example: Data set refreshes on 5/9/2024, start date in slicer should be 5/8/2024. We still need to be able to manually adjust the start day to a past date if we need to analyze historical data.

[lbendlin · Accepted solution]

Use the Relative Date filter option in the Filter Pane, or create your own default.

- create a string representation of your date column, replace the latest date with a string "Latest"
- sort that new column by the original date column
- add a slicer or visual/page/report level filter
- set the filter to "Latest"
- publish the pbix to the workspace/app