How to Remove Null Rows in Tableau

How do you remove null rows in Tableau? You remove null rows in Tableau by filtering out records where specific fields are null, either in Power Query (Data Source tab), through calculated filters in worksheets, or by excluding nulls directly in the visualization, ensuring your analysis focuses only on complete and relevant data.

For enterprise executives, removing null rows from Tableau dashboards improves data quality, ensures accurate reporting, and eliminates confusion caused by incomplete or invalid records in strategic views.

Step 1: Identify Where Nulls Exist

Begin by locating the null values in your dataset:

1. Open your worksheet in Tableau Desktop
2. Look for (Null) entries in dimensions or blank cells in measures
3. Use Filters or highlight tables to surface rows with missing values

Tip: Use a summary view or null checking calculated fields to understand how nulls impact your metrics.

Step 2: Filter Null Rows in a Worksheet

If you’re working within a worksheet, filter nulls from a specific field:

1. Drag the relevant field (e.g., Customer Name, Region, Sales) into the Filters shelf
2. Uncheck the (Null) option from the filter list
3. Click OK

This removes rows where that field is null from your current view.

Use Case: Ideal for cleaning visual output without changing the underlying dataset.

Step 3: Create a Calculated Field to Exclude Nulls

To filter based on multiple fields or conditions:

1. Right-click in the Data pane > Create Calculated Field

Use logic like:

tableau

NOT ISNULL([Customer Name]) AND NOT ISNULL([Sales])

2. Name the field (e.g., Valid Records)
3. Drag the calculated field to the Filters shelf and filter to True

Advanced Tip: This approach gives you flexibility to clean data based on combinations of null conditions.

Step 4: Remove Null Rows from the Data Source (Optional)

For a permanent solution, filter out nulls at the Data Source level:

1. Go to the Data Source tab
2. Click Add Filter (in the top-right of the data preview)
3. Select the field(s) you want to filter
4. Choose Exclude Null Values

This prevents null records from even entering the visualization layer.

Data Management Tip: Filtering early improves performance and reduces downstream complexity.

Step 5: Handle Nulls in Joins or Relationships

Nulls often result from joins or missing keys. To reduce null rows:

• Use inner joins to exclude unmatched rows
• Use data blending carefully to avoid introducing null-linked records
• Check for unmatched keys that may produce blank values

Join Strategy Tip: Switch from a left join to an inner join to eliminate rows with nulls from the secondary table.

Step 6: Use ZN or IFNULL for Measures (Optional)

If you want to show zero instead of removing nulls:

• Use ZN([Sales]) or IFNULL([Sales], 0) to replace nulls with zeros
• This keeps rows in place but avoids blank output in numeric fields

Visualization Tip: Use this when you want to display zero activity rather than remove records entirely.

Final Thoughts

Removing null rows in Tableau helps deliver cleaner, more reliable dashboards that executives can trust. Whether you’re analyzing customer data, financials, or operations, eliminating incomplete records ensures that visualizations reflect real performance, not missing information.