Switch Parameters

Hi Asmaa-elsheikh,

Depending on your requirements, we recommend that you create two additional date tables and manage the relationship between them.

Please follow my steps:

1. Create a new table named Date that is based on the minimum and maximum values in the date field of your original table.
   Date = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))​
   

    

2. Then create another table called DatePeriod to define the specialized date period:
   DatePeriod = UNION(ADDCOLUMNS(DATESMTD('Table'[Date]),"Type","MTD"),ADDCOLUMNS(DATESQTD('Table'[Date]),"Type","QTD"),ADDCOLUMNS(DATESYTD('Table'[Date]),"Type","YTD"),ADDCOLUMNS(DATESBETWEEN('Table'[Date],TODAY()-7,TODAY()),"Type","ThisWeek"))
3. In addition, we need to manage the relationship between them as shown below: 
   
4. In this way, we can use the type field in DatePeriod table as a slicer in order to filter all the visualizations in one slicer:
   Note that I've changed a couple of the time data to 2023 in order to reflect the change:
   
   

   Best regards,

    

   Joyce

    

   If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.