Slicer not gettting filtered by other slicers

[Anany]

Hi,

I've created 3 slicers Year (Multi-select), Month (Multi-select), and Day  (Single select) now when the end user selects 31 in the day slicer & changes the values in the month slicer the day slicer is not getting filtered.
For ex-

The user selected 31 in the day slicer - July month -> Now when we change the month slicer to June keeping the day 31 in the day slicer it gets stuck at 31 but ideally, it should show 30 because June has only 30 days

Is there any fix? I've already tried using other slicers like chiclets, and hierarchical slicers and it is showing the right values but I want to use dropdown whereas these other custom slicers only have the option of the List.

[v-easonf-msft]

Hi, @Anany 

For now, there is no fix for that. You have to clear the selection of 'Day' dropdown slicer and reselect.

You can also try to customize a hierarchy with these three fields and then apply it to the slicer.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Anany , If they are coming from same date table , then they should filter each other. if not you need create a measure and check for not blank.

countrows(filter(Day, Day[Year] = selectedvalue(Year[Year])  Day[Month] = selectedvalue(Month[Month]) ))

[Anany]

@amitchandak  Thanks for your time. Please find the attached test pbix file I've tried implementing the above measures but it is not working. The issue is it is getting stuck (Not getting filtered by Month Slicer).

https://drive.google.com/file/d/121ic53JHoMVDFpVrbYkTTdAR2fwv-J9v/view?usp=sharing