I usually use this method - MUST a floating, fixed size dashboard, in a layout container put a "filler" sheet and the filter itself. The layout container must have a X/Y that takes it off the dashboard size (hard to explain in text, but hopefully you get the idea). The "filler" sheet pops the filter in/out based on the criteria you want.
If you're talking about Z-index (layers in front or behind) it sounds like you're trying to put 2 filters in the same place. This won't work properly on Desktop, but it will work once you publish to Server.
If you get stuck, send a TWBX and I can fix it for you
I'm curious: does this solution work on Tableau Public as well? Or will it only work on Server? I've been looking for ways to free up a bunch of dashboard space and this trick has always intrigued me and would do the trick, but wasn't sure if it worked on Public...
Very cool, Chris. I'll dig into this and check out how it works!
Thanks for the reply. I was able to implement the solution on my own . The trick is used to used a Blank sheet and a Floating text box for the filter to hide.
Take the filter and blank sheet in a floating horizontal or vertical container depending on the filter alignment and space that you are working in. I user horizontal container since all my filters are on top and side by side .
I put the blank sheet and filter in the horizontal container , blank sheet on the left and filter on the right. In the blank sheet i specified my condition using the third filter that will have my sheet pop out/pop in .
So when the condition is true the sheet pops out and pushed the filter to the right and then the Text box is a floating one and hides the filter . When the condition is false , the blank sheet pops in and moves to left and the filter pops back . I formatted the color and borders and formatting in such a way that the end user wont notice the difference .
Just an FYI , you have keep adjusting your sheets and filter side by side in the container until you get the desired result. it wokred great on mine.
Sorry I can't share the workbook since it has client data and I can't publish that publicly.
But I appreciate your help here.
can you post an example of this? also can you maybe post a link that shows how to apply a condition to a sheet?
I have total 6 filters
1st filter have 5 values.
I want to show a different filter (filter 2 to filter 6) based on value selected in filter 1.
How can i achieve this.