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.
@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).