Forum Discussion

Ananthan's avatar
Ananthan
Frequent Visitor
3 years ago

Date Slicer selection based on another date slicer

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.

Need Help

2 Replies

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    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's avatar
      Ananthan
      Frequent Visitor
      3 years ago

      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])))