How to Change a Field Based on Another in Tableau

How do you change a field based on another in Tableau? You change a field based on another in Tableau by using calculated fields with conditional logic, such as IF, CASE, or parameter-driven expressions, enabling dynamic display of values based on the state of another dimension or measure.

For enterprise executives, conditional logic in Tableau makes dashboards more intelligent, responsive, and aligned with business logic, allowing different views or metrics to be shown automatically based on user selections or data conditions.

Step 1: Identify the Fields You Want to Link

Start by determining:

• The condition field: the one that triggers a change (e.g., Region, Product Type, or Status)
• The target field: the one you want to change or calculate differently (e.g., Sales, Profit, Label)

Use Case: You should show different metrics (like Profit or Revenue) depending on a selected product category.

Step 2: Create a Calculated Field Using IF or CASE

Option 1: Using IF Statements

tableau

IF [Region] = “East” THEN [Sales]

ELSEIF [Region] = “West” THEN [Profit]

ELSE [Quantity]

END

This field dynamically changes what value is displayed based on the region.

Option 2: Using CASE Statements

tableau

CASE [Product Type]

WHEN “Furniture” THEN [Profit]

WHEN “Technology” THEN [Sales]

ELSE [Quantity]

END

Tip: IF is more flexible (supports ranges and logical expressions), while CASE is simpler for exact matches.

Step 3: Add the Calculated Field to Your View

Once the calculated field is created:

1. Drag it into your Rows, Columns, or Label shelf
2. Use it in tooltips, KPIs, or conditional formatting
3. Filter, color, or sort based on the new logic-driven field

Visual Insight: Conditional logic fields help personalize the view per region, team, product, or status, without duplicating visuals.

Step 4: Use Parameters to Make Fields User-Controlled (Optional)

To allow users to choose which field to display:

Create a Parameter:

1. Right-click in the Data pane > Create Parameter
2. Name it (e.g., “Metric Selector”)
3. Add values like “Sales”, “Profit”, “Quantity”

Create a Calculated Field:

tableau

CASE [Metric Selector]

WHEN “Sales” THEN [Sales]

WHEN “Profit” THEN [Profit]

WHEN “Quantity” THEN [Quantity]

END

Add the parameter to the view as a dropdown and use the calculated field for display.

Executive Insight: This gives viewers control to toggle between metrics in real time, improving engagement and dashboard utility.

Step 5: Test and Validate the Output

• Apply filters to check the logic works correctly
• Verify output across all possible input values
• Use tooltips or dual-axis charts to compare outputs if needed

Validation Tip: Add helper labels or annotations during testing to visualize the triggering logic.

Final Thoughts

Changing a field based on another in Tableau allows for smarter, more adaptable dashboards that mirror real-world business logic. Whether you’re dynamically switching metrics, customizing labels, or building user-driven views, conditional fields elevate the power of Tableau as an enterprise-grade analytics tool.