How to Hide Rows in Tableau

Hiding rows in Tableau is a fundamental skill for creating clean, focused, and professional-looking dashboards. Whether you're removing irrelevant data points, filtering out nulls, or simplifying a complex view, knowing how to selectively hide data is crucial. This guide will walk you through several easy-to-follow methods, from a quick right-click to dynamic conditional filtering.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Hide Rows in Tableau?

Before jumping into the "how," let's quickly cover the "why." You might need to hide rows in your crosstab or visualization for a few common reasons:

• To Remove Irrelevant Data: Your dataset might include categories, regions, or products with zero sales or activity. Hiding these keeps your audience focused on what matters.
• To Clean Up the View: Null values, empty rows, or placeholder data can make a report look messy and unprofessional. Hiding them instantly cleans it up.
• To Focus on a Specific Subset: Sometimes you need to analyze a specific segment of your data, like top-performing products or regions that meet a certain threshold, without permanently deleting the underlying data.
• To Improve Readability: An overly cluttered visualization is hard to read. Hiding less important rows can make charts and tables much easier to understand at a glance.

Fortunately, Tableau gives you multiple ways to achieve this, each suited for different scenarios.

Method 1: The Quickest Fix - Right-Click and Hide

This is the most direct and intuitive method for hiding one or more specific rows. It's perfect when you see a row in your view that you just want to get rid of instantly, without thinking about complex rules.

Let’s say you have a simple text table showing Sales by Sub-Category.

You notice that a few sub-categories like "Furnishings" and "Labels" have low sales, and you want to remove them from this particular view to focus on the top performers.

Step-by-Step Instructions:

1. Identify the Row(s): In your view, find the row header (the label for the row, e.g., "Furnishings") that you want to hide.
2. Select a Single Row: Right-click directly on the row header. A context menu will appear.
3. Select "Hide": From the menu, simply click on Hide. The row will immediately disappear.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Hide Multiple Rows at Once:

If you want to hide several rows at the same time:

1. Click on the first row header you want to hide.
2. Hold down the Ctrl key (or Cmd on Mac) on your keyboard.
3. While holding the key, click on the other row headers you want to hide. They will all be highlighted.
4. Once you’ve selected all of them, right-click on any of the highlighted headers and select Hide.

What Happens Behind the Scenes (And How to Unhide)

When you use the "Hide" option, Tableau automatically creates a filter for you. It puts the dimension pill (in our case, Sub-Category) onto the Filters shelf and configures it to exclude the items you hid.

To see this or to unhide the rows:

• Find the Sub-Category dimension on your Filters shelf.
• Right-click on it and choose Edit Filter.... You will see a list of all your sub-categories, with the ones you hid deselected. Simply check the boxes next to their names to bring them back.
• Alternatively, if you want to quickly bring everything back, right-click any row header in the view and select Show Hidden Data.

Method 2: More Control with the Filters Shelf

Manually filtering provides a more deliberate and transparent way to hide rows. Instead of reacting to what's in the view, you build the rule upfront. This method is great because the logic is always visible right there on the Filters shelf.

Using the same Sales by Sub-Category example, let's say you want to exclude "Fasteners," "Labels," and "Supplies" from the start.

Step-by-Step Instructions:

1. Drag to Filters: From the Data pane on the left, click and drag the dimension that defines your rows (Sub-Category) onto the Filters shelf.
2. Choose Your Values: A dialog box will pop up, displaying all the members of that dimension. By default, all should be checked.
3. Deselect to Hide: Uncheck the boxes next to the members you want to hide — in our case, "Fasteners," "Labels," and "Supplies."
4. Use the Exclude Option: Alternatively, you could check only the boxes for the items you want to hide and then check the Exclude box in the top right. This tells Tableau to show everything except what you've selected. This can be faster if you're hiding more rows than you're keeping.
5. Apply the Filter: Click OK. The selected rows will now be hidden from your view.

This method gives you a clear visual cue on the Filters shelf that data is being excluded, making it easier for you or others to understand what the visualization is showing.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 3: Dynamic Hiding with Calculated Fields

What if you want to hide rows based on a dynamic condition, not a fixed list of names? For instance, maybe you want to hide any sub-category with sales under $50,000. If your data updates tomorrow and a new sub-category falls below this threshold, it should automatically hide. This is where calculated fields are incredibly powerful.

Step-by-Step Instructions:

1. Create a Calculated Field: Go to the Data pane, click the small dropdown arrow at the top, and select Create Calculated Field....
2. Name Your Calculation: Give it a descriptive name like "Sales > 50k".
3. Write the Formula: Your formula will define the condition. In this case, you want to check if the sum of sales for each row is greater than 50,000. The formula is a simple boolean (True/False) check:
4. Apply the Calculation as a Filter: Click OK to save the field. Now, find your new "Sales > 50k" field in the Data pane and drag it onto the Filters shelf.
5. Set the Filter Condition: A small dialog will appear asking how you want to filter. Check the box for "True", which tells Tableau to only keep the rows that meet your condition (i.e., where sales are greater than 50,000). Click OK.

Your view will now dynamically update. Any rows with sales below $50,000 are hidden. If the underlying data changes later, the view will adjust automatically without any manual intervention.

Another Common Example: Hiding Null Values

You can use the same logic to hide rows where a key measure is null. Create a calculated field like:

NOT ISNULL(SUM([Sales]))

Drag that to the Filters shelf and set it to "True" to only show rows that actually have a sales value.

Method 4: Hiding Rows While Preserving Grand Totals

This is a more advanced but extremely useful trick. What happens when you use a regular filter to hide rows? Tableau removes them entirely, which means they are also excluded from calculations like grand totals.

Imagine you have a report showing Profit by Sub-Category, and you want to show a grand total at the bottom. Some sub-categories have negative profit. If you use a regular filter to hide these negative-profit rows, your grand total will increase because those negative values are no longer being subtracted. This can be misleading.

To hide the rows from the view but keep them in the total calculation, you need to use a table calculation as a filter. This works because of Tableau's order of operations - it calculates totals before applying table calculation filters.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step Instructions:

1. Build the Initial View: Place Sub-Category on the Rows shelf and SUM(Profit) on the Text mark. Go to Analysis > Totals > Show Column Grand Totals to add the total at the bottom. Take note of this initial total.
2. Create the Table Calculation Filter: Create a new calculated field. Let's call it "Filter for Positive Profit". The formula simply references the measure you want to use for filtering:

This method lets you present a clean list focusing on positive results, while still reporting an accurate and complete grand total. It's a key technique for executive-level dashboards.

Final Thoughts

Knowing how to effectively hide rows in Tableau is a simple way to take your reports from cluttered to clean. By mastering these different methods — from the simple right-click to dynamic calculations — you can tailor your visualizations to perfectly suit your analytical needs and your audience's expectations.

Building actionable dashboards can require many steps, from connecting data and creating visuals to filtering and formatting. We designed Graphed to remove that friction. Instead of clicking through menus to hide rows or writing formulas for filters, you can just tell the platform what you want in plain English, like "Show me sales by product, but only for products that sold more than 1000 units." Our AI-powered analyst handles the data wrangling for you, turning hours of manual report building into a 30-second conversation.