Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Slicer not gettting filtered by other slicers



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.







Community Support
Community Support

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



Super User
Super User

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

Power BI Features || Datamarts: || Field Parameters :
Time Intelligence Decoded : || 50+Power Query List Functions : Learn Power Query List
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

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

Helpful resources

September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Solution Authors