Yes, it is doable. Can you please provide a sample workbook?
Otherwise, please refer to the thread below about how to achieve it
Hope this helps
I only know of very complicated dashboard structure which can make it happen.
Prepare three completely white sheet
1. when parameter = X "show"
2. Always white
3. Always white
If this helped, please mark my answer as correct / helped to close the thread.
Not from inbox but from original post.
yes it works for only 2 or 3 filters, what about if u have 10 or more fitlers?
Depends on how many sheets you want to swap.
Multiple filters on one sheet can be handled by same concept as group (block)..
Here's another approach - setup your sheet swap, and then select only relevant values on your filter menu. This will make it disappear when the sheet is not on screen.
280891.twbx 2.5 MB