Date Slicer selection based on another date slicer

[Ananthan]

I have Year, month, day slicer in first page, i have to  set the slicer selection in second page based on first page slicer date plus one day,

For eg in first page i have selected year-2022, month-August, Day-20 means, in second page it should select August 21st date.

both are different slicers, that means diffrent fields.

[v-chenwuz-msft]

Hi @Ananthan ,

Unfortunately, the range (between) of the date slicer does not change with the other slicers. If you change the date slicer to list, then consider using the slicer synchronizer to synchronize the slicers of both pages.

Use the following code to make another slicer change

Measure = IF( SELECTEDVALUE('Table 2'[Date])>MAX('Table'[Date]),1)

Best Regards

Community Support Team _ chenwu zhu

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

[Ananthan]

I have tried the above measure. but its not working for me. could you please give me the alternate solution for this.

If i select the  eg 20th August 2022 in created date slicer in the first page. i have to filter the grid in the  second page, that grid contains only those are all the projecs scheduled on the 21st Aust 2022.

I have created the measure like below, but its not working.

Next Day service count = calculate(COUNT('Table2'[Project Number]),FILTER('Table2',DATEVALUE('Table2'[Schedule_Date])= datevalue(SELECTEDVALUE(Table1[Created On])))