Auto update two slicers using the same field data

[pimo]

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 · Accepted solution]

@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,