Dynamic calendar based selected date on visuals

[absowdud]

Hi there, 

I'm trying to create a dynamic chart within PBI DT. When user selects a valid date – the measures should update automatically. We need the same for the line graph. i.e The weeks should shift accordingly, only displaying the past 12 weeks from the ‘End Date’ selected. If the 6th June 2024 is selected. March 11th is the start of that 12 week period.
If the user selects 26th May 2024, The start of the 12 week period should be 4th March, so the start of the graph x-axis should be ‘March 4’ and the end should be ‘May 20’. Any help would be massively appreciated! 

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to 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.

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