Date filter interaction

[rajendraongole1]

Dear All,

I have a slicer selection on right side with Year as seperate slicer and date slider as another slicer.

if i select the year and change to 2022, Below date is also changing accordingly to 2022 dates. when i change in below date with some period eg: Jan to June. after that If i select the Year to 2023 below date is not changing back to 2023 Dates.

Please suggest.

after that i changed back to 2023

Below date is showing different dates not 2023 Dates

[rajendraongole1]

Thanks for the response 

I have an interaction between both of the slicers.

Activity: First change the Year from 2023 to 2022. 

Date slicer is working as expected.

if we do changes in Date slicers Eg: change the date slicer between some period after that if we change the Year slicer not taking the selection.

[rubayatyasmin]

are you getting only one value in the year? like the image below

[rubayatyasmin]

Hi, @rajendraongole1 

select your date fiter. then in the ribbon got format>> edit interaction 

turn on filter for your second slicer. this works

[rajendraongole1]

already done . but 

if you change the Date 

If you change the Date slicer with some particular period Eg: 1/1/2022 to 4/1/2022

after that if you can change the year to another Like 2023. it will not work or reset. Can you please check and confirm?

[Ritaf1983]

Hi @rajendraongole1 

You need to modify interractions between these 2 slicers :

Result:

Link to the sample file 

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