How to force date slicer to apply to visuals?

[whodey]

My report page has a "between" date slicer that filters a matrix visual. The data is displayed as one date per column, going back several years, so the visual is meant to be filtered to reduce dates shown. It also filters a line chart, which allows for a larger range to be appropriately displayed.

The user is meant to have flexibility to select the upper and lower dates in the slicer. To help the user I've added buttons linked to bookmarks that filter for "last 30 days" and "last 60 days". These bookmarks filter the slicer only, rather than the page or the actual visuals. This is to allow for adjusting the dates via slicer after selecting one of the bookmarks (filter pane will be hidden so user won't be able to easily clear a relative date filter.

My issue is that filtering the date slicer does not force the slicer to be applied to the visuals. Is there a way to force the slicer selection?

[ajohnso2]

If you were to create a column based on date that would calculate the min date (i.e. 1st day 30 days ago/60 days ago) and the max (e.g. Today).

e.g.

If 'Calendar'[Date] = TODAY() - 30 days then "30 Days Start" else if 'Calendar'[Date] = TODAY() - 60 days then "60 Days Start" else if 'Calendar'[Date] = TODAY() then "Today" else Calendar'[Date]

You can add a 2nd hidden date slicer populated with your new column that is synced to the visible one. Your bookmarked buttons should be updated to set the start date as 30/60 Days Start and the end date as "Today". These values would always be constant assuming your model is refreshed daily.