How to dynamically hide a dashboard zone based on a filtered Mission ID?

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!