How to update the filter based on another filter?

[Chris123Terr]

Hi, I have this problem.
I have one slicer per year and another slicer per month. Years before 2016 are through December, but 2016 only has through October.
So when I select in the slicer
"2014" and "December" everything works perfect, however, when I select 2016, the month gets stuck and shows me nothing because there is no December 2016.

Slicer by year

Slicer by month

Result:

when i change to 2016

The month is stuck in December.
It does not show me anything because in December there is no data for 2016

[onurbmiguel_ · Accepted solution]

Hello 

My sugestion : 

Use the date slicer like this: 

the other sugetion is that when you change the year the user need to uncheck the month. 

Best regards

Bruno Costa | Solution Supplier

Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

Take a look at the blog: PBI Portugal