New: Cookbooks and AI ExplanationsStep-by-Step recipes to solve problems connected to Roadmaps and Cheat Sheets. Need more details? Use AI buttons for structured and simple explanations with concrete examples throughout the whole platform.Take a look
One manager wants revenue, another wants units sold, and I'm tired of maintaining two nearly identical sheets.
What you'll have at the end
One chart with a dropdown parameter that swaps between revenue, units, and profit without touching the underlying worksheet.
You need
A Tableau worksheet that already shows one real measure, such as total sales, broken down by a dimension like product category, connected to a data source that also holds the other measures a viewer might want to see instead, such as units sold and profit.
Not covered
A control that updates automatically when someone selects a mark on a different sheet; that's a parameter action, a separate technique for a viewer who wants the swap to happen for them instead of picking it themselves.
Leans on
Synchronize a dual axis so two measures share one honest scale
Reach for this instead when a viewer needs to see two metrics on screen at once, side by side, rather than switching between them one at a time.
Publish a dashboard your manager can open alone
Once this chart lives on a dashboard a stakeholder opens without you, this is the recipe for making sure they can actually reach it there.
Checked 26 Aug 2026
Part of the Tableau cookbook