Forum Discussion
Date filter interaction
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
5 Replies
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.
are you getting only one value in the year? like the image below
You need to modify interractions between these 2 slicers :
Result:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, rajendraongole1
select your date fiter. then in the ribbon got format>> edit interaction
turn on filter for your second slicer. this works
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?
