How to Ungroup in Tableau

Grouping data in Tableau is a great way to simplify your dashboards by combining related members of a dimension, but you'll almost certainly need to reverse that process. Whether you’re trying to dig into the details or simply want to undo a previous grouping, this guide will walk you through the various ways to ungroup in Tableau.

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 Tableau Groups and Why Use Them?

Before we learn how to ungroup, let's quickly touch on why you'd group data in the first place. In Tableau, a "group" is a new field you create by combining members of an existing dimension. Think of it as creating custom buckets for your data.

For example, imagine you have a State dimension in your dataset. You could create a group called Sales Region that combines individual states like this:

• West: California, Washington, Oregon, Nevada, Arizona
• Midwest: Illinois, Ohio, Michigan, Wisconsin, Minnesota
• Northeast: New York, Massachusetts, Pennsylvania, New Jersey, Connecticut

This is incredibly useful for:

• Simplifying Visualizations: Instead of showing 50 individual state bars on a chart, you can show a handful of regional bars, making the viz cleaner and easier to read.
• Fixing Messy Data: Sometimes your data has small variations like "USA," "U.S.A.," and "United States." You can group these together into a single "United States" member to clean things up.
• Segmenting Data for Analysis: You can create custom groups for things like "Top 10 Performers vs. The Rest" or group products into high, medium, and low profitable categories.

When you create a group, Tableau adds a new field to your Data pane, usually marked with a paperclip icon and named something like State (group). This new field acts like any other dimension, meaning you can drag it onto rows, columns, or the marks card.

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

3 Ways to Ungroup in Tableau

The method you choose for ungrouping depends on what you’re trying to accomplish. Are you just trying to temporarily break down a group in a single view, or do you want to get rid of the group entirely? Here are three ways to do it, from the quickest temporary fix to a permanent removal.

Method 1: Ungrouping Directly From a Visualization Header

This is the fastest and most common method when you want to look at the individual members of a group in specific charts or sheets - without deleting the group itself. This approach is non-destructive and only affects the current view.

Let's say you have a bar chart showing Profit by Sales Region, where "Sales Region" is your group.

Step-by-Step Instructions:

1. In your worksheet, find the chart or table that uses your group.
2. Locate the headers for the grouped members. In our example, these would be the labels "West," "Midwest," and "Northeast" on the axis.
3. Right-click on any of these group headers (for example, right-click on "West").
4. From the context menu that appears, select Ungroup.

That's it! Tableau will immediately dissolve the group within that chart and display the individual members instead. The Sales Region (group) field will remain in your Data pane, available for use in other worksheets.

When to use this method:

• When you're exploring the data and need to quickly drill down into specifics.
• When you only want to change a single worksheet and leave other visualizations untouched.
• When someone asks a follow-up question in a meeting like, “Can you show us the state-level data for the West region?”

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

Method 2: Ungroup by Removing the Group Field from the View

Another simple way to "ungroup" a visualization is to remove the grouped field from the worksheet entirely. Similar to the first method, this approach doesn't delete the group, it just stops using it in your current view.

Instead of visualizing by your group, you'll replace it with the original dimension.

Step-by-Step Instructions:

1. Identify which shelf or card the group field is on. It could be on the Rows shelf, Columns shelf, or even on the Marks card (affecting Color, Size, Label, etc.). The field will have the paperclip icon.
2. You can now do one of two things:

For example, if your Sales Region (group) pill is on the Color mark to color-code a map, you could drag the original State field onto the Color mark. The map will instantly change from showing regions to showing individually colored states.

When to use this method:

• When you want to visualize data by a completely different dimension instead of the group.
• It is ideal for removing groups affecting your colors, labels, or marks, where finding the header is not easy.

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 3: Deleting the Group From the Data Pane Permanently

If you have decided that you no longer need a group anywhere in your entire Tableau workbook, you can delete it permanently. This will remove the grouped field from the Data pane, making it unavailable for future use in any worksheet.

Heed a word of caution: This action is permanent. Once you delete the group from the Data pane, it's gone for good. If the group is used on any sheets, those visualizations will break.

Step-by-step Instructions:

1. Navigate to the Data Pane on the left-hand side of your Tableau workspace.
2. Find the group field you want to delete (it will have the paperclip icon and be named something like [Dimension Name] (group)).
3. Right-click on the group field and select Delete.
4. Tableau will show a warning if the group is being used in existing worksheets. This is a helpful feature that prevents you from accidentally breaking your dashboards. Confirm the deletion only if you are sure you want to proceed.

Final Thoughts

Whether you need a quick drill-down for analysis, want to re-visualize your data using the original dimension, or need to get rid of a group permanently, Tableau gives you several straightforward ways to get it done. The key is understanding if your goal is temporary for a single sheet or a permanent removal from your entire workbook.

Learning the clicks and tricks of any data tool takes time. At some point, you end up feeling more like a data janitor than a strategist. We built Graphed to cut through this complexity. Instead of wrestling with groups, shelves, and pills, you simply connect your data and ask questions like, "Show me my sales total by state instead of region." Graphed instantly builds the exact chart you need, allowing you to focus on discovering insights, not memorizing how-to guides.