How to use a single date slicer to produce a column chart showing past x weeks

[Cascavel]

I am trying to achieve the Performance table below displaying historic data for x weeks based on a starting date selected from a slicer.   Can anyone help me please.   The slicer is doing multiple jobs, but essentially I would like to use the selected value from the slicer, but avoid the use of the slicer on my data (which of course reduces the column chart down to one column based on selection).   

Please see this visual for more information 

Any help very gratefully received... Thank you 

[Cascavel]

Thansk Daniel - very helpful

[Daniel29195 · Accepted solution]

@Cascavel 

this video should help you out .

https://www.youtube.com/watch?v=d8Rm7dwM6gc&t=186s

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🙏