One date slicer to affect all other date slicer

[Anonymous]

Hello,

Is it possible to get one date slicer to affect all the other date slicers in the page? If the main slicer is set from 01/01/2020 to 01/02/2020, then date slicer1, date slicer 2 and date slicer3 should also show from 01/01/2020 to 01/02/2020.

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Create a measure as below and make the slicer filtered by it. After that we should edit the interaction of the two slicers to make it work.

Measure = IF( MAX('Calendar'[Calendar Date])>= [Start Date],1,0)

For more details, please check the pbix as attached.

[amitchandak]

Then why would you like to have three slicers?

[Anonymous]

@amitchandak What I meant is if we choose the date for slicer 1 as 01/01/2020 to 01/02/2020, then slicer 2 and slicer 3 should show the same dates.

[Greg_Deckler]

You could possibly do this as a measure that you would use to filter your slicers. So, create a measure like:

Measure = IF([Date2] IN 'Table'[Date1],1,0)

Then filter on 1, maybe?

[PaulDBrown]

@Anonymous 

Just out of curiosity...why do you need several date slicers on the same page?

If you have one date slicer, you can then use the edit interactions under "Format" to decide which visuals it affects...or you can use the visual/page or report level filters in the filter pane.

[Anonymous]

@PaulDBrown  unfortunatley the completion dates for each process is different and since we want data according to each process dates, separate date slicers were set. But now I want it to be affected by one of the main date slicers