Hi everyone,
I’m working on a Tableau dashboard where users select a Mission ID using a filter dropdown.
Some Mission IDs are milestone-based, while others are not.
I have a field [Milestone Rank], and the condition for a milestone-based Mission ID is:
COUNTD([Milestone Rank]) > 0
I have a separate dashboard section containing several milestone-related charts. What I want is:
- If the selected Mission ID is milestone-based → show the milestone section.
- If the selected Mission ID is not milestone-based → completely hide the milestone section.
- When the section is hidden, I also want the empty space to collapse, rather than leaving a blank area.
- The Mission ID list comes from the database, so new Mission IDs can be added over time.
- Ideally, I want to keep the Mission ID as a filter dropdown, rather than requiring the user to manually change another Show/Hide parameter.
I tried using Dynamic Zone Visibility, but Tableau does not show my Boolean calculated field as an available value for “Control visibility using value.”
I also tried a Boolean parameter for Show/Hide, but then the user has to manually change the parameter every time they select a different Mission ID, which isn't practical.
Is there a way to make Dynamic Zone Visibility respond automatically to the selected Mission ID while keeping the Mission ID as a filter?
If not, what would be the recommended Tableau approach for achieving:
Mission ID filter → detect whether milestone exists → automatically show/hide a dashboard zone → collapse the space when hidden?
Thanks!
#Tableau Desktop & Web Authoring #Reports & Dashboards #Tableau Cloud #Automation #Analytics
Chris's set idea is the right way, I built it on Superstore to make sure it really drives the zone (screenshots below). A few details that made it work:
Create a set on Mission ID (right-click the field > Create > Set) and use it in place of the Mission ID filter, so every sheet that was filtered by Mission ID now has the set on Filters showing IN. Then right-click the set > Show Set, and on the card's menu choose Single Value (dropdown). For your users it looks almost the same as the dropdown they have now, the only difference is there's no (All) option in single value mode.
Keep the set dropdown outside the container you hide. If it sits inside it, it disappears with the section and nobody can switch back.
The visibility field must be one value for the whole workbook, so the whole comparison goes inside the braces:
{ FIXED : COUNTD(IF [Mission ID Set] THEN [Milestone Rank] END) > 0 }
Written as { ... } > 0 it won't show up in the list, that's the bit Chris mentioned. And because it's a FIXED, normal filters don't affect it. If another filter on the dashboard should count too (date, region...), right click it and Add to Context.
Put the milestone sheets in one tiled container, select the container, go to the Layout tab, tick Control visibility using value and pick the field. When it's False the container goes away and the tiled items around it take the space, so no blank area.
In my test the field is "does the selected state have any order with a 50% or bigger discount": Texas shows the section, California hides it. Same structure as yours, just swap in Mission ID and Milestone Rank.
