<< Back

Hiding parameters and filters in Tableau – Version 2

It appears something has changed in the latest versions of Tableau so my previous post regarding how to “hide” parameters and filters in Tableau is no longer working. https://theinformationlab.co.uk/2017/01/26/hiding-parameters-filters-tableau/

Don’t worry though, the brains at The Information Lab usually have a back-up plan. Big thanks to Chris Love for pointing me towards this, demonstrated in his great Tableau Public viz – https://public.tableau.com/profile/chrisluv#!/vizhome/OSCARUNIT-SPACEEXPLORATION/InFlight

A similar post also exists from a few years ago https://theinformationlab.co.uk/2014/06/19/popping-parameters/ but I thought I would provide an update.

I have updated the workbook that I used in the previous blog, this is still available on Tableau Public, it should still work with older versions of Tableau – https://public.tableau.com/profile/andrew.pick#!/vizhome/HidingParametersandFilters/Dashboard1

Previously I used layout containers to float over the top of the parameters we wanted hiding, but we can no longer click through those containers on server. Instead we are going to force the parameter to move in the layout container, depending on whether we want to see it or not.

I have added a floating layout container to my dashboard which contains the parameter, and two worksheets, one above (green) and one below (red). For this example I will colour the worksheets to make them easier to see, ideally you would have them all white, or the same colour as your background.

The green worksheet is set up as follows

 

 

The filter calculation is as follows, and is set to “False” in the filter –

 

So when the level select parameter is showing 1, this filter will hide the Green Worksheet, when anything else is selected in the parameter this worksheet will show.

And the blank is just to ensure the sheet disappears when nothing is selected

The Red Worksheet is set up exactly the same, except the level one filter is set to “True”

 

Back on the dashboard we can see when Level 1 is selected in the parameter, only the Red Worksheet is visible, forcing the parameter up.

When anything other than Level 1 is selected, the Green Worksheet is visible, forcing the parameter down.

We can now position the layout container, using the x,y positioning in the layout tab, so that the container is off the dashboard.

Before –

After –

By setting the y value to be negative the top part of the container is not visible on the dashboard, so when the Level selection parameter equals Level 1, the Red Worksheet becomes visible and the Level 2 Parameter is pushed “off” the dashboard, it can no longer be seen or accessed until the Level selection parameter is changed.

 

We can then change the format of the worksheets so that they are white, repeat the process for the Level 3 Parameter and we now have “hiding” parameters which only appear when we want them to.

 

The new workbook is available on Tableau Public – https://public.tableau.com/profile/andrew.pick#!/vizhome/HidingParametersandFiltersV2/Dashboard1

Andrew Pick

Manchester, UK

30 thoughts on “Hiding parameters and filters in Tableau – Version 2

  1. Thank you… But this only works IF the parameters is purposely located at the most top of the screen..

    Do you have an example if it’s located anywhere in the screen?

    1. Hi Andrew,

      That’s great. However, for filter 2 and filter 3 you won’t be bale to make filters as it’s blocked. Any workaround on that?

      1. Hi Andrew, nice trick! I made it to work but when I publish it I have an extra square hanging outside my layout. Should it be that way? I´m working with fixed resolution.

  2. Hi Andrew,

    I have created a date range parameter (with a list of pre-built date ranges as well as a custom option) and a start and end date parameters but I only want to show the custom start/end date parameters when the custom option is select.

    I tried your solution but it didn’t quite work – can you help me?

    1. Andrew, it’s hiding as it should but I just can’t select the start or end date parameters when the custom option is selected.

  3. Hi Andrew,
    Can the same be achieved without any floating objects? In my dashboard, everything is tiled and the dashboard is automatically sized to fit all the resolutions.

  4. Hi Andrew,

    Facing the same issue as Richard. The hiding/showing works with a floating layout container and a floating parameter. However, when the parameter is visible, it cannot be selected as it lies under the floating container.

  5. The solution does not work if the dashboard is to be viewed by users who have different screen resolutions because floating objects get resized as per the resolution and meticulous placing of floating/non-floating filters required for this solution stops working.

    1. Hi Rachana,

      I would suggest always using fixed dashboard sizing when using floating objects to stop this issue.

      Thanks

  6. Hi,

    I tried this but I am having an issue with filter selection. Once the filter is visible, not able to select it.

    Not sure why??

    Can you guide me

    1. Hi Naman,

      Not sure why that would be the issue, have you tried downloading the example workbook on tableau public to see how that works?

      Thanks

      Andy

  7. I have start and end date parameters but those should show or hide based on a filter value selection, is that possible? e.g. I have start and end date for monthly range, similarly I have start and end dates for Quarterly and Weekly and I have a filter called Interval which is multi select having Quarterly, Monthly and Weekly and based on what values are selected in Filter, those set of dates should be shown.

    1. Hi Rajesh,

      You could create a similar calculation using your filter option as you would a parameter, so if your filter value = Quarterly then the sheet would show other wise it wouldn’t. This would block the parameters similar to how I have set this up with parameters. I think that should work.

      Thanks

      Andy

  8. It Worked for me, Thanks !! I never knew we could adjust x position to negative number that is an amazing thought.

  9. Hi,

    It is partially working for me. I have a container on my Dashboard that container itself is tiled but the parameters inside it are floating. I added true and False sheets inside it and when activated, the false sheet is squeezing all the parameters rather than completely hiding them.

    I wish we could simply put them on the parameters that need hiding and when these sheets are deactivated, we could click through them.

  10. It worked for me by placing a floating worksheet over the top of the parameters when I did not want them to be seen. I masked the display by showing the date range of the data with a light background color to block custom start and end date parameters. One could easily enough use a white background with nothing displayed, however, it leaves a large white space in a vertically displayed filters section.

  11. I have the same detail even in the example (Version 2) of Andrew happens, The vertical layer do not allow use the drop down at least that I manually send to back. Is there a solution for this? Thank you

    1. Hi Guillermo,

      Unfortunately these are the only options I am aware of, without looking I can’t really advise. Maybe have a look in the Tableau forums to see if anyone else has come up with a solution.

      Thanks

      Andy

  12. I have gotten the dashboard very close, but cannot seem to get the sizing right to both move it off the screen when not needed, yet show in an appropriate spot when it is needed. Would you potentially be able to take a peek if I could email the workbook?

Leave a Reply

Your email address will not be published. Required fields are marked *