Forum Discussion
How to update the filter based on another filter?
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
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
1 Reply
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