Display X last week based on user selection(week selected)

[Anonymous]

I have a problem building this formula 

I have a Line Chart showing some values per week 
I need that when a user selects a speceific wekk e.i week 50 the line chart filter to show the Week 50 and 12 Previuos weeks
so the line chart will show info from week 38 up to week 50 

is this possible?

The columns that I use for the Line Chart are just 
Week Number 
and a measure to show a percetange value 

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and attached pbix file.

One of the ways is to create disconnected Week Number Table and use that as a slicer.

Sum value: =
VAR weeknumberselect =
SELECTEDVALUE ( 'Week Number'[Week Number], MAX ( 'Week Number'[Week Number] ) )
RETURN
CALCULATE (
SUM ( Data[Value] ),
KEEPFILTERS ( Data[Week Number] <= weeknumberselect
&& Data[Week Number] >= weeknumberselect - 12 )
)

[VahidDM]

Hi @Anonymous 

Check this link:

https://www.vahiddm.com/post/weekly-time-intelligence-dax

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/