Forum Discussion

pimo's avatar
pimo
Frequent Visitor
9 years ago
Solved

Auto update two slicers using the same field data

Hi,

 

I have two slicers in my project, both can filter a date range.

 

First slicer has "Data" as Field, from Table1. This slicer is set as "Relative date slicer"

 

The same for the second slicer: it has "Data" as Field, from Table1. This second slicer is set as "Between"

 

Then if I do:

1) select "Last" "1" "Days", from slicer 1. The target date is 26/07/2917

2) then in the slicer2, set From 01/01/2017 To 02/02/2017

 

I wish that the first slicer change according to the values of second slicer

 

Actually I want that changing one slicer, the other slicer auto updatzes it self

 

Thank for you support

 

 

 

 

  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    pimo

     

    In this scenario, since your two slicers are populated with same Date field, it's not possible to make it cascading filter between two slicers. To achieve your goal, I suggest you duplicate your Date column and each slicer uses one Date field.

     

    Regards,

1 Reply

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    9 years ago

    pimo

     

    In this scenario, since your two slicers are populated with same Date field, it's not possible to make it cascading filter between two slicers. To achieve your goal, I suggest you duplicate your Date column and each slicer uses one Date field.

     

    Regards,