Filtering problem in dashboard

[alejandrobarce1]

I have a problem with multi-filtering in my dashboard. At the top, I have a "month" filter, which helps the viewer set the month of the year statistics he will be looking; that's the main filter, but on every graphic we have another filter, which depending on the selected month, shows the week number to choose. I will add some photos to make this easier to understand:

That was the month filter, now, for the graphics filter, I chose the month "May" which is Mayo in spanish. These are the weeks that the other filter is showing:

There we can see that shows the number of every week and we can choose the one that we want to look at. I will choose the week number 20 to show the problem.

So there I chose week 20. The problem starts when I leave that 20 chosen, and I change the month of the main filter. Let's say I choose April, which is Abril in spanish, this is what happens:

It shows a graphic without any data, and that happens because of this:

Even though I changed the month, it keeps showing the week 20, which is not in the month April, and that makes the dashboard fail while another person is watching it.

How can I solve this problem? Is there a way to program or put an action that makes the second filter delete the option we chose  when we change an option from the main filter?

Thanks!

[ArkadyZagdan · Accepted solution]

There are definitely some work arounds to this.

- merging months with weeks into one field and allowing a user to select week with month using one filter
- Adding a refresh data button allowing to quickly get out of this problematic sittuation;)