Graphed LogoGraphed
Graphed LogoGraphed
FeaturesUse CasesIntegrationsPricing

How to Replace Values in Tableau

Cody Schneider••8 min read

Nothing slows down building a great dashboard like messy data. You connect your data source in Tableau, start dragging fields onto your view, and immediately notice problems: NULL values, inconsistent capitalization, typos, and different terms that all mean the same thing. This is a normal part of data analysis, and fixing it is a fundamental skill for creating clean, accurate, and professional reports.

GraphedGraphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Watch Graphed demo video

This tutorial will show you the most common and effective methods for replacing values directly within Tableau. We'll walk through step-by-step instructions for using aliases, calculated fields with IF and CASE statements, and the grouping feature, so you can choose the best approach for any situation.

Why Bother Replacing Values in Tableau?

Before we jump into the "how," let's quickly touch on the "why." You might be tempted to just live with the messy data, but cleaning it up is critical for a few key reasons:

  • Accuracy: If you have "USA," "U.S.," and "United States" scattered in a country field, Tableau treats them as three separate countries. This will make your "Sales by Country" chart completely wrong. Consolidating these ensures your aggregations are correct.
  • Clarity: Replacing cryptic codes (like "P-001") with human-readable names ("Premium Subscription") makes your dashboards instantly understandable for your audience. No one should need a separate decoder ring to read your report.
  • User Experience: Cleaning up NULL or blank values by replacing them with something like "Not Specified" or "Organic" makes filters and legends in your final dashboard look much more polished and professional.

Method 1: The Quick Fix with Aliases

The fastest and simplest way to replace a few distinct values in a dimension is by using aliases. An alias is just a new name you assign to a specific member of a dimension. This method doesn't change the underlying data, it only affects how the data is displayed in your Tableau workbook.

This is perfect for basic cleanup tasks, like correcting a typo, changing an abbreviation, or renaming a category.

When to use Aliases:

  • You have a small, finite list of values to change.
  • You are working with a discrete dimension (the blue pills).
  • You don't need complex logic, you're just doing a simple one-to-one replacement.

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Step-by-Step: How to Create Aliases

Imagine your data has a "Traffic Source" field with values like "google," "direct," and "bing." You want to capitalize them for a cleaner look.

  1. In the Data pane on the left side of your screen, find the dimension you want to edit (e.g., "Traffic Source").
  2. Right-click on the dimension and select Aliases... from the context menu.
  3. An "Edit Aliases" dialog box will appear. You'll see two columns: "Value (Original)" and "Value (Alias)."
  4. Simply click in the "Value (Alias)" column next to the member you want to change and type in your new value. For our example:
  5. Click OK.

That's it! Any worksheet that uses the "Traffic Source" dimension will now display the capitalized alias "Google" instead of the original "google."

Method 2: The Power Player - Calculated Fields

When you need more flexibility and logic than aliases can provide, calculated fields are the way to go. A calculated field lets you create a new field in your data source based on a formula you define. This is the most powerful and scalable method for replacing values.

When to use Calculated Fields:

  • You need to apply logic ("IF this, THEN that").
  • You have many values to change and want a more manageable solution than a long list of aliases.
  • You need to handle values based on conditions in other fields.
  • You want a durable solution that can handle new incoming data that might match your logic (e.g., automatically categorize all future UTM campaigns containing "PPC").

We'll look at the two most common functions for this: IF statements and CASE statements.

GraphedGraphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Watch Graphed demo video

Using an IF/ELSEIF Statement

The IF statement is a staple of data manipulation. It tests a sequence of conditions and returns a value based on the first condition that evaluates to true.

Example: Replacing a NULL Value

Let's say a "Campaign" field sometimes has NULL (blank) values for organic traffic. We want to replace these NULLs with the prettier and more descriptive name "Organic Search."

  1. Right-click in a blank area of the Data pane and select Create Calculated Field.
  2. Name your new field something intuitive, like "Campaign (Cleaned)."
  3. In the formula box, enter the following logic:
IF ISNULL([Campaign]) THEN "Organic Search"
ELSE [Campaign]
END

Breaking down this formula:

  • IF ISNULL([Campaign]): This checks if the value in the original "Campaign" field for a given row is NULL.
  • THEN "Organic Search": If the condition is true, it returns the string "Organic Search."
  • ELSE [Campaign]: If the condition is false (meaning the field is not NULL), it simply returns the original value from the "Campaign" field.
  • END: This closes the IF statement.

Now, instead of using the original [Campaign] field in your views, use your new "[Campaign (Cleaned)]" field for a perfectly cleaned-up dimension.

Example: Replacing Multiple Values with ELSEIF

You can chain conditions together using ELSEIF, which is useful for more complex categorizations. Let's say you want to group several specific campaigns into broader categories.

IF CONTAINS([Campaign], "summer_sale") THEN "Summer Promotion"
ELSEIF CONTAINS([Campaign], "black_friday") THEN "Holiday Promotion"
ELSEIF ISNULL([Campaign]) THEN "Organic"
ELSE "Evergreen"
END

This formula checks each campaign name. If it contains "summer_sale," it's labeled "Summer Promotion." If not, it checks for "black_friday." If neither is true, it checks for NULLs. For everything else, it assigns the value "Evergreen."

Using a CASE Statement (A Cleaner Alternative)

When you have a long list of direct, one-to-one replacements, a lengthy IF/ELSEIF statement can get messy. This is where the CASE statement shines. It's often easier to read and more efficient for matching exact values.

Example: Standardizing state abbreviations.

Imagine your data has shipping information with state names inconsistently entered as "Calif.," "CA," and "California."

  1. Create a new calculated field named "State (Standardized)."
  2. Enter the following CASE statement:
CASE [State]
WHEN "Calif." THEN "California"
WHEN "CA" THEN "California"
WHEN "N.Y." THEN "New York"
WHEN "NY" THEN "New York"
ELSE [State]
END

Breaking down this formula:

  • CASE [State]: This tells Tableau you're going to evaluate the values in the "State" field.
  • WHEN "Calif." THEN "California": When the value is "Calif.," return "California."
  • ELSE [State]: This is a fallback. If none of the WHEN conditions match, just return the original value.
  • END: Closes the CASE statement.

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Method 3: Grouping Similar Values

Sometimes your goal isn't just to rename one value, but to combine several values into a single category. Tableau's grouping feature is a fantastic UI-driven way to handle this, especially for cleaning up typos or consolidating categories on the fly.

When to use Grouping:

  • You want to quickly combine multiple members of a dimension into a single member.
  • You're cleaning up multiple typos for the same item (e.g., "Brooklyn," "Brooklin," "Brookln").
  • You're creating higher-level categories from more granular ones (e.g., grouping "Carrots," "Lettuce," and "Onions" into a "Vegetables" category).

Step-by-Step: How to Group Values

  1. In the Data pane, right-click on the dimension you want to clean up (e.g., "City").
  2. Select Create > Group....
  3. A dialog box will appear with a list of all members in that dimension.
  4. Find the similar values you want to combine. Hold down the Ctrl key (or Cmd on Mac) to select multiple members at once (e.g., "New York," "NYC," "N.Y.C.").
  5. With them selected, click the Group button. Tableau will create a new grouped value and collapse the original members under it. You can double-click this new group name to rename it to something clean, like "New York City."
  6. Repeat this process for any other groups you need to create.
  7. Optionally, check the box for "Include 'Other'" to lump all ungrouped members into a single "Other" category.
  8. Click OK.

This creates a new grouped field in your Data pane, which you can identify by the paperclip icon. Just like with calculated fields, you'll use this new "City (group)" field in your analysis instead of the original.

Final Thoughts

Mastering value replacement is a huge step toward building reliable and insightful Tableau dashboards. Whether you're using a quick alias for a typo, a powerful calculated field to enforce business logic, or the group feature to consolidate categories, having these skills allows you to turn messy raw data into a clean, trustworthy asset for analysis.

Of course, manually cleaning data in tools like Tableau, while effective, is often just one step in a much larger, time-consuming reporting process. For many teams, hours are still spent connecting to various platforms, pulling reports, and wrestling with data before any analysis can even begin. At Graphed, we automated this entire workflow. By connecting your marketing and sales data sources just once, you can skip the manual cleanup and start building powerful, real-time dashboards instantly using simple, natural language. It's like having a data analyst on your team who works in seconds, not hours.

Related Articles