Relative date slicer with single selection?

[Anonymous]

Hi! This is my first time posting to a forum, but I've been searching for days and can't figure it out. I am a relatively new user.

Here is my challenge:

I have a slicer that allows users to select a single date from a drop-down menu.

Based on that date, I need to create a table and several charts that show information from the last three fiscal years. For example, if the user selects July 2023, I need to show results from October 2020 to October 2023. If the user selects July 2019, I need to show results from October 2017 to October 2019. If that's not possible, I would also be okay with showing only up to the selected date if necessary (not going into the future).

My table looks something like this:

product | sales | date | fy

Thank you!

[lbendlin]

You can create measures based on SELECTEDVALUE(<your date filter here>)

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...