how to use period picklist slicer to filter date slicer

[Anonymous]

Hi experts,

I have a date slicer and a period picklist slicer:

 

What I do is :

1, create a Calendar table extracted from my fact table and create a copy of it (called "hidden calendar");

2, then i created three tables which only contains the dates of "current week", "previous week" and "YTD" separately:

3, then i append these three tables into one "period picklist table" :

4, then, i created the relationships like this:

'Calendar'[Date] -(1 to many*)-> 'weekly visual'[Date]

and

'Calendar'[Date]' <-(1 to many*)-> 'Period Picklist'[Date]

Problem is, the period slicer (lower one) can not filter the date slicer correctly. for example, I select "YTD" in the period slicer, though the data in all the matrix visuals show correctly, but the date slicer does not change to the date range of YTD (from 2-1-2023 to 8-7-2023). I have to manually move the slider to make the date slicer show the correct date range. (i already make the interactions: let date slicer not filter the period slicer, but the period slicer can filter the date slicer.)

i want to let the period slicer filter the date slicer when i click any of the period. Can anyone help me to make it? Thanks in advance!