Why Is Tableau Showing Null Values?

Seeing "Null" pop up in your Tableau dashboard can be slightly alarming, but it’s rarely a sign that something is broken. Null values simply represent the absence of data, and they’re a normal part of data analysis. This tutorial will walk you through exactly what Null means, the most common reasons you're seeing it, and several practical ways to handle it, so you can control your data and create clearer reports.

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 Does "Null" Actually Mean in Tableau?

First, let’s be clear about what Null is and isn’t. A Null value is not the number zero (0), nor is it a blank text string (" "). It is a unique marker that signifies an unknown or missing value. Think of it like a blank field on a form, if someone skips a question, their answer isn't "zero," it's just nonexistent.

This distinction is important because Tableau treats Nulls differently in calculations and visualizations. For example:

• In mathematics: Any calculation involving a Null will result in another Null (e.g., 100 + Null = Null).
• In aggregations: Functions like SUM(), AVG(), or COUNT() will simply ignore Null values. AVG(1, 9, Null) is 5 (10 / 2), not 3.33 (10 / 3).
• In visualizations: Tableau often defaults to not plotting Null values, which can lead to gaps in your line charts or missing bars in your bar charts.

Understanding that Null means “nothing is here” is the first step to figuring out how to manage it.

Common Reasons You're Seeing Null Values in Tableau

Nulls can appear for many reasons, ranging from issues in your original data file to the specific ways you’ve joined or blended data. Here are the most frequent culprits.

1. Gaps in Your Source Data

The simplest and most common cause of Null values is that the data is missing from the original source file. If a cell in your Excel spreadsheet, Google Sheet, or database table is empty, Tableau will read it as a Null value. There’s no complex logic here - if the data isn't there to begin with, Tableau can't display it.

Example: You have a spreadsheet of monthly sales, but someone forgot to enter the data for March. When you connect this data to Tableau and create a bar chart of sales by month, March will either be missing or its value will be Null.

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

2. Data Joins That Don’t Find a Match

When you join two or more tables in Tableau, Nulls can be created intentionally depending on the join type. If you use a LEFT, RIGHT, or FULL OUTER join, Tableau will look for matching records between the tables based on the fields you select.

• A LEFT Join includes all records from the left table and only the matching records from the right table. If a record in the left table doesn't have a match in the right table, the fields from the right table will appear as Null.
• A RIGHT Join does the opposite, keeping all records from the right table.
• A FULL OUTER Join keeps all records from both tables. If a record from either table doesn’t have a match in the other, the corresponding fields will be Null.

Example: You have a table of Customers and a separate table of Orders. You perform a LEFT join from Customers (left) to Orders (right). If any customers have not yet placed an order, all of the fields from the Orders table (like OrderID and OrderDate) will be Null for those customers.

3. Issues with Data Blending

Data blending is another way to combine data from different sources in Tableau. Unlike joins, blending keeps the data sources separate and queries each one independently, aggregating the results in the final view. Nulls can appear if a record in your primary data source doesn't have a matching record in the secondary data source based on the linked fields.

The key here is the asterisk (*). If a dimension from a secondary source shows an asterisk in your view, it means there are multiple matching values in the secondary source for a single value in the primary. If it’s blank or Null, it means there were zero matching values.

Example: You have a primary data source for Employee Sales and a secondary source for Regional Sales Targets. You link them by Region. If an employee belongs to a region that doesn't have a defined sales target, the Sales Target field from the secondary source will show as Null for that employee’s records.

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

4. Calculations that Produce Nulls

Your own calculated fields can also be a source of Null values. Certain logical functions or mathematical operations will produce Nulls as a result.

Common calculation-driven Nulls include:

• CASE Statements: If a CASE statement runs into a value that doesn't match any of the conditions or doesn't have an ELSE condition, it will return Null.
• DATEPARSE Function: If you use DATEPARSE to convert a text string to a date, a Null will occur if the text formatting doesn’t match what the function expects. DATEPARSE('dd/MM/yyyy', 'March 03, 2024') will return Null because the format is wrong.
• Division by Zero: Operations like SUM([Sales]) / SUM([Quantity]) can sometimes involve dividing by zero, which results in a Null.

How To Effectively Handle Nulls in Tableau

Now that you know why Nulls appear, you can decide how to handle them. The right approach depends on your objective. Do you want to hide them, correct them, or replace them with another value? Here’s a step-by-step guide to your options.

Option 1: Filter Out Null Values

If the records containing Null values aren't important to your analysis, the quickest solution is simply to remove them from the view.

How to do it:

1. Drag the field that contains Null values onto the Filters card.
2. A dialog box will appear showing all values in that field.
3. Uncheck the box next to "Null."
4. Click "OK." The records with Null values will now be hidden from your visualization.

This is best for when Null records represent junk data or should not be included in any part of the analysis.

Option 2: Replace Nulls with a Default Value

Often, you want Nulls to be treated as 0 (for numbers) or as a text category like "Missing" or "N/A". You can accomplish this with native Tableau functions in a calculated field.

For Numbers: The ZN() Function

The ZN() function stands for "Zero Null" and is the perfect tool for converting numerical Nulls into 0s.

• Syntax: ZN([Your Measure])
• Example: To fix a [Sales] field that has Nulls, create a calculated field called "Sales (cleaned)" with the formula:

ZN([Sales]) 

Now, use the "Sales (cleaned)" field in your charts. Every time Tableau finds a Null value in the original [Sales] field, it will replace it with a 0 in your new field.

For Any Data Type: The IFNULL() Function

The IFNULL() function is more versatile and works for both numbers and dimensions.

• Syntax: IFNULL([Your Field], 'Replacement Value')
• Example: To replace Nulls in a text field called [Category], you might use:

IFNULL([Category], 'Unknown') 

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

Option 3: Alias the Values for Display

Sometimes you don't need to change the underlying data, you just want to change what's displayed on the screen. Aliasing is perfect for this. It replaces the "Null" text in your visualization with something more descriptive like "Data Missing" or "N/A."

How to do it:

1. In your view, find the "Null" indicator that often appears in the bottom right corner. Click on it.
2. Select the option to "Edit Aliases" or "Format Data" (depending on your Tableau version).
3. Enter your desired alias in the dialog box that appears.

This change only affects how the data is displayed and not how it is stored or calculated.

Final Thoughts

Navigating Nulls is a fundamental skill in cleaning and interpreting your data in Tableau. Remember that they indicate missing values, not necessarily errors. Understanding whether they come from your original source data, a specific type of join, or a tricky CASE statement is the first step. From there, you can choose the right tool for the job, whether it's filtering them out, converting them with ZN() or IFNULL(), or simply aliasing them for a cleaner report.

Grappling with these data inconsistencies is often a sign of the manual friction inherent in traditional reporting. The process of downloading CSVs, wrangling them in spreadsheets, and meticulously building visualizations is where many of these data gaps and mismatches originate. At Graphed, we help you skip that entire process by connecting directly to your data sources - like Google Analytics, Shopify, and Salesforce. You can build real-time, interactive dashboards just by describing what you want to see, allowing you to get to insights faster without fighting with Nulls and data cleansing roadblocks.