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
Is it possible show/hide or control what's shown in one parameter's dropdown based on the selection in another parameter?
ReplyDeleteI 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
DeleteIs 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
ReplyDeleteYeah, I mean...I think you'll just replicate this numerous times.
DeleteThis doesn't seem to work anymore when I download the workbook. Am I missing something?
ReplyDeleteIt seems to work fine for me. What version are you using?
DeleteGreat 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.
ReplyDeleteAre you able to share an example with me? flerlagek@gmail.com
DeleteHi Kevin,
ReplyDeleteI 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 ?
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