Dynamic Drop-Down Menus

https://www.flerlagetwins.com/2020/10/dynamically-change-your-drop-down-menus.html 

How to dynamically change drop down menus based on a parameter selection. Think of the parameter as allowing the user to specify what they want to highlight or filter and then based on that selection use a set control to show the available values based on that parameter selection.

Use a calculated field to return a dimension based on the parameter selection (e.g. CASE / WHEN). Create a SET from the calculated field and use a SET CONTROL to allow the user to make selections from the available items in the SET.

Add a calculated field that returns TRUE based on the selections in the SET then add the calculated field to color or filter.

Example: https://public.tableau.com/app/profile/kevin.flerlage/viz/CreatingDynamicDrop-DownMenus/DynamicDrop-DownMenu-Filter 





Comments

Post a Comment

Popular posts from this blog

The (Almost) Definitive Guide to Show/Hide Buttons in Tableau Dashboards

https://www.youtube.com/watch?v=p1yop6z6kbc   Show/Hide buttons in Tableau allow you to do just that, show or hide containers, worksheets, blanks, text, legends, even the title. You can now hide ANY object on a dashboard. In particular, I love to use them to use the show/hide buttons for a filters container. It's always a good idea to name every object in your dashboards in the Layout section so they are easier to identify when creating the buttons. In this video I will walk you through: 0:00 Intro and demo 0:57 Add a show/hide text button to a worksheet 1:44 Add a show/hide icon to a container 2:25 How to show/hide all filters 3:07 Allowing user to view a single worksheet 3:27 How to organize buttons into a container
Read more