Forum Discussion
Relative date slicer with single selection?
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!
1 Reply
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-Forum/ba-p/963216
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/1447523
