How to Find Null Values in Tableau

Nothing brings data analysis to a screeching halt faster than discovering your reports are skewed by missing data. In Tableau, these missing values are called Nulls, and they can silently wreak havoc on your calculations, creating misleading charts and inaccurate KPIs. This guide will walk you through several practical methods for finding, highlighting, and handling Null values in Tableau so you can trust your data and your dashboards.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Are Null Values and Why Do They Matter?

First, let's be clear about what a Null value is. A Null doesn't mean zero, and it doesn't mean a blank space (" "). A Null is the absence of a value - it's an unknown or empty cell in your dataset. This might happen because of an error during data entry, an incomplete record in your database, or an intentional omission.

Why should you care? Because Nulls can seriously compromise your analysis:

• Skewed Aggregations: If you calculate an average, Tableau (by default) ignores Nulls completely. For example, if you have ten sales records, but three have Null values for revenue, the average will be calculated based on only the seven records with data. This might inflate your average and give you a false sense of performance.
• Broken Calculations: Certain calculations can fail or produce unexpected results when they encounter a Null. If you're trying to add a bonus to a sales figure and the sales figure is Null, the result will also be Null.
• Misleading Visualizations: Nulls can cause gaps in line charts, blank spaces in tables, or simply be excluded from bar charts, making your visualizations look incomplete or, worse, just plain wrong.

Finding where these values are hiding is the first step toward building accurate and reliable dashboards. Let’s look at a few ways to do it.

Method 1: Use the Data Source Pane Filter

The simplest way to get a quick overview of Nulls is by using the filter option directly in your Data Source pane. This is a great starting point when you first connect to your data and want to check its health before you start building anything.

How to Do It:

1. Navigate to the Data Source tab in the bottom-left corner of your Tableau workspace.
2. Look for the list of your data sources and find the Filters section in the top-right corner. Click the Add button.
3. A dialog box will appear. Click Add... again to select the specific field you want to check for Nulls.
4. Once you've selected a field (e.g., "Customer Region"), another dialog will pop up. In this window, you’ll see several tabs at the top. Click on the Null tab.
5. Here you have two straightforward choices: Include Null values or Exclude Null values. If you select "Include Null values" and then click "OK," your data preview will ONLY show the rows where that specific field is Null.

This method is perfect for an initial audit. You can quickly see which rows are missing critical information. However, this is a C-level filter, meaning it applies to your entire data source. It's less flexible if you want to handle Nulls differently on a sheet-by-sheet basis.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Method 2: Identify Nulls in Your Worksheet View

Sometimes you don't notice Nulls until you've already started building a visualization. Tableau has a helpful, albeit subtle, way of telling you when Nulls are present in your current view.

How to Find the Null Indicator:

1. Create a simple worksheet. For example, drag a dimension like Product Category to the Rows shelf and a measure like Sales to the Text mark to create a crosstab table.
2. Take a look at the bottom-right corner of your workspace. If there are Nulls present in the data being used for the view, you’ll see a small grayish pill that says something like "4 nulls."

This Null indicator is more than just a notification, it’s interactive. Clicking on it opens a small dialog with a few options:

• Filter data: This is the most common choice. It creates a filter that automatically excludes the rows containing Nulls from your visualization. This is a quick fix to clean up your chart, but be aware that you are hiding data, which can affect your totals.
• Show data at default position: This option tries to plot your Nulls, often at the zero mark on an axis. This can be useful for categorical data but can be very confusing for continuous data (like sales or dates), as it groups all unknown values at a single point. Use this with caution.

This on-the-fly method is great for dealing with Nulls as they appear in specific visualizations, giving you immediate control over how they are displayed on each worksheet.

Method 3: Create a Calculated Field to Isolate Nulls

For the most power and flexibility, nothing beats a calculated field. By creating a calculation, you can flag, count, replace, or filter Nulls with surgical precision. The primary function you'll use for this is ISNULL().

The ISNULL() function is a simple boolean test. It looks at a field you specify and returns True if the value is Null and False if it's not.

ISNULL([Your Field Name])

How to Use the ISNULL() Function:

1. Right-click anywhere in the Data pane (the left-hand sidebar) and select Create Calculated Field.
2. Give your calculated field a descriptive name, like "Sales Data Missing?".
3. In the formula editor, type: ISNULL([Sales]).
4. Click OK.

You've now created a new dimension that works like a flag. Here are a few ways you can use it:

• Filter Your View: Drag your new "Sales Data Missing?" calculated field to the Filters shelf. You'll be asked which values to include: True or False. To see only the rows with missing sales data, select True. To exclude them, select False.
• Highlight Nulls with Color: Drag the "Sales Data Missing?" field onto the Color mark in a crosstab or scatter plot. Tableau will assign one color to True (your Nulls) and another to False (your valid data), instantly showing you exactly where the problems lie.
• Generate a Quick Count: Double-click the "Sales Data Missing?" field to add it to your view, then drag Number of Records to the view as well. This will give you a simple table showing you exactly how many rows have Nulls and how many do not.

Practical Recipes for Handling Null Values

Once you've found the Nulls, what do you do with them? Simply filtering them out isn't always the best approach. Here are a few common calculated field "recipes" for managing them effectively.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Recipe 1: Replacing Nulls with Another Value

Sometimes you don’t want to remove Nulls, you want to replace them with a default value, like zero for numbers or "N/A" for text. This keeps your record counts consistent and prevents calculations from breaking.

For Numbers - The ZN() Function:

The ZN() function stands for "Zero Null." It takes a numerical field and returns a 0 if it's Null, otherwise it returns the original value. This is extremely useful for measures.

ZN([Profit])

For Any Data Type - The IFNULL() Function:

The IFNULL() function is even more versatile. It checks a field and returns a value you specify if it’s Null.

To replace Null profit with 0 (does the same thing as ZN()):

IFNULL([Profit], 0)

To replace a Null product description with friendly text:

IFNULL([Product Description], 'Description not provided')

Recipe 2: Counting Null Values for a KPI

Want to monitor how many records are missing key data? You can create a calculated field specifically to count the Nulls. This is great for a data quality dashboard.

Calculated Field Name: Count of Null Orders

Formula:

SUM(IF ISNULL([Order ID]) THEN 1 ELSE 0 END)

This formula checks every row. If a row has a Null Order ID, it assigns a 1, otherwise it assigns a 0. The SUM() around the whole thing then adds up all the 1s, giving you an exact count of the Nulls. You can place this on a KPI card to keep an eye on your data quality over time.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Recipe 3: Excluding Nulls from a Specific Part of a Calculation

Let's say you have a complex calculation and you only want to include records that have complete data for certain fields. For example, maybe you want to calculate the total sales but only for products that have a Sub-Category defined.

Calculated Field Name: Sales from Defined Sub-Categories

Formula:

IF NOT ISNULL([Sub-Category]) THEN [Sales] END

This formula checks if the Sub-Category field is not Null. If it has a value, it returns the Sales amount for that row. If Sub-Category is Null, the formula returns a Null. When you then use this new calculated field in your view (e.g., SUM([Sales from Defined Sub-Categories])), it will only aggregate the sales from the rows where the sub-category was present.

Final Thoughts

Tackling Null values is a fundamental skill for anyone working in Tableau. You can start with simple checks in the Data Source pane, use the visual indicator for quick fixes on a worksheet, or create robust calculated fields with ISNULL(), ZN(), and IFNULL() for ultimate control. Mastering these methods will make your dashboards more accurate, your insights more reliable, and your life as an analyst a whole lot easier.

While Tableau offers powerful tools for data cleanup, sometimes the process of finding and fixing these issues across multiple sources feels like a job in itself. With Graphed , we simplify the entire analytics workflow. You can connect your marketing and sales platforms in minutes, and instead of manually writing formulas to fix data issues, you can just ask in plain English. For example, you can tell Graphed, "Create a dashboard showing revenue by campaign but exclude any sales with no customer region," and it handles the filtering for you, turning hours of data prep and dashboard building into a 30-second conversation.