Set RelativeDate Slicer Anchor Based on Another Date Slicer

[MCassady]

Hello,

Here is a picture of my dashboard so far:

I need the following:
- Graph 1 shows data based on the selected date in DateSlicer1

- Graph 2 shows the last 28 days of data based on the selected date in DateSlicer1

My current thought, is to have a dateslicer2, in relativedate mode, the affects graph 2, but I can't figure out how to set its anchor date to the date that is selected in DateSlicer1.

Is this possible? Ideally, we'd be able to change the date in 1 place, and hide the second date slicer from the end user.

EX) Change the date to 2022/01/01 -> Graph 1 shows data for 2022/01/01 and Graph 2 shows data for 2021/12/05 to 2022/01/01.

[lbendlin]

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

[MCassady]

Hey @lbendlin thanks for replying.

Here is a link to a sample pbix. 

https://drive.google.com/file/d/1qE8_0l-Y3Krgt9y5xojJKfV5DvS-yEAv/view?usp=sharing

Hopefully i uploaded that correctly.

I tried to explain my problem clearer in the file as well.