Dynamically Show & Hide Parameters & Filters based on another Parameter Selection

 


For the past couple of years, I have seen a question pop up over and over and over.  I’ve probably seen this question asked two dozen times, both directly, via social media, and via the Tableau forums.  The question is simple.  I have a parameter with a value of A.  When I change that parameter to a value of B, it changes the view.  At the same time, when the value is set to B, I want to provide additional options to my user.  The additional options come in the form of a second parameter or filter.  However, I only want that additional parameter or filter to show when the value of B is selected, not when the value of A chosen.  So how do I show or hide a parameter/filter based on the selection of another parameter?


Although this is not something that is built into the standard functionality of Tableau, everything has a work-around.  Please check out my Tableau Public Workbook then watch the following video to see how to do this.  


Click on the image to watch the video.  


 



 

Kevin Flerlage, November 2, 2020

Twitter LinkedIn Tableau Public

 




10 comments:

  1. Is it possible show/hide or control what's shown in one parameter's dropdown based on the selection in another parameter?

    ReplyDelete
    Replies
    1. I don't think you can do this. Even a dynamic parameter only updates when the workbook opens. However, you could certainly use a set control. Check this out: https://www.flerlagetwins.com/2020/10/dynamically-change-your-drop-down-menus.html

      Delete
  2. Is there a way to use this solution to control more than one collapsible container based on the parameter. Currently that is only set in the button options so the transparent can only control one container. thanks

    ReplyDelete
    Replies
    1. Yeah, I mean...I think you'll just replicate this numerous times.

      Delete
  3. This doesn't seem to work anymore when I download the workbook. Am I missing something?

    ReplyDelete
    Replies
    1. It seems to work fine for me. What version are you using?

      Delete
  4. Great work, is it possible to show/hide or control what's shown in one parameter's dropdown list? I use one parameter for multiple dashboards and the calculations are tied to them so it would be 400x the work and time to duplicate the parameter.

    ReplyDelete
    Replies
    1. Are you able to share an example with me? flerlagek@gmail.com

      Delete
  5. Hi Kevin,
    I have a similar scenario ,Lets say i have more 30 values in primary parameter and more than one filter in secondary ,how is that dynamic Show hide works should i need to create 10 different sheets ?

    ReplyDelete
    Replies
    1. Any chance that you could share a workbook with me? Also, what version are you on? The new Dynamic Zone Visibility feature helps with a ton of these types of use cases. flerlagek@gmail.com

      Delete

Powered by Blogger.