cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anany
Helper I
Helper I

Slicer not gettting filtered by other slicers

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.

Anany_0-1659510369922.png

Anany_1-1659510478155.png

Anany_3-1659510603748.png

 

 

 

3 REPLIES 3
v-easonf-msft
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

 

 

amitchandak
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: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s || 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).

 

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

Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors