How to Create a Category in Tableau

Trying to make sense of a dimension with dozens or even hundreds of members can make any Tableau chart feel cluttered. That's where grouping comes in, allowing you to combine related items into logical categories to simplify your view and reveal higher-level insights. This guide will walk you through several easy ways to create and use categories 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 is a Category in Tableau? And Why Should You Bother?

In Tableau's official terminology, what we often call a "category" is known as a "Group." A group is a new dimension you create by combining multiple members of an existing dimension. Think of it as putting similar items into the same bucket.

For example, instead of looking at sales for 50 individual US states, you could group them into regions like 'West Coast', 'Midwest', and 'Northeast'. Or, instead of analyzing performance across 200 different product SKUs, you could group them into product lines like 'Apparel', 'Accessories', and 'Footwear'.

So, why is this useful? Grouping helps you:

• Simplify Complex Visualizations: A bar chart with 5 regional bars is much easier to read and understand than one with 50 state bars.
• Summarize Data Meaningfully: It allows you to analyze performance at a higher, more strategic level, which is often more useful for business decisions.
• Clean Up Messy Data: Sometimes your data contains slight variations that should be treated as one. For instance, you might have 'United States', 'US', and 'U.S.A.' which can all be grouped into a single 'USA' category.

Let's dive into the two primary methods for creating these groups in Tableau.

How to Create a Category Using the Data Pane (The Standard Method)

The most straightforward way to create a group is directly from the Data Pane on the left side of your worksheet. This method gives you the most control and is great for when you already know which members you want to group together.

Here's the step-by-step process using the classic example of grouping states into regions.

Step 1: Locate and Right-Click Your Dimension

In the Data Pane, find the dimension you want to group. In our case, it's the State dimension. Right-click on it.

Step 2: Choose 'Create' > 'Group...'

From the context menu that appears, hover over Create and then select Group…. This will open the 'Create Group' dialog box. Here, you'll see a list of all the members within your chosen dimension.

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

Step 3: Select Members and Group Them

Now for the fun part. Select the members you want to combine into your first category. To select multiple members, hold down the Ctrl key (or Cmd on a Mac) and click on each member.

Let's create a 'West Coast' group. Select 'California', 'Oregon', and 'Washington'. Once they are highlighted, click the Group button underneath the list.

Step 4: Rename Your New Group

Tableau will automatically create a group and name it based on the members you selected (e.g., 'California, Oregon & Washington'). This isn't very descriptive, so you'll want to rename it. Simply click on the name in the list, and then click Rename. Let's call it 'West Coast'.

Step 5: Repeat for Other Categories

Continue this process for all the other categories you want to create. For example, you could group 'Texas', 'Arizona', and 'New Mexico' into a 'Southwest' group. Keep creating and renaming groups until all your members are categorized as needed.

Step 6: (Optional) Handle "Other" Members

What about all the members you haven't assigned to a group? You can lump them all together by checking the box labeled Include 'Other'. This creates a catch-all category named 'Other', which is handy for keeping your visualization clean without having to manually group every single member.

Step 7: Click 'OK' and Use Your New Dimension

Once you're happy with your groups, click OK. You'll see a new field appear in your Data Pane, likely named State (group), with a paperclip icon next to it. You can now drag this new dimension into your view just like any other field to create summarized visualizations.

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

How to Create a Category Visually from a Chart

Sometimes, it's easier to identify items you want to group together when you're looking at them in a visualization. Tableau’s visual grouping feature makes this incredibly simple and intuitive.

Let’s say you have a bar chart showing Sales by Product Sub-Category, and you notice several office-related items could be combined.

Step 1: Create Your Visualization

First, build a simple chart. Drag Sales to Columns and Sub-Category to Rows to create a horizontal bar chart.

Step 2: Select the Marks You Want to Group

Now, select the visual elements (the bars, in this case) that you want to group. Hold down the Ctrl key (or Cmd on a Mac) and click on the bars for 'Binders', 'Envelopes', 'Labels', and 'Paper'.

Step 3: Click the Group Icon (Paperclip)

As you select the bars, a small tooltip will appear. On this tooltip, you’ll see several options, including an icon that looks like a paperclip. This is the Group icon. Click it.

That's it! Tableau immediately replaces the selected bars with a single, aggregated bar and creates a brand new group dimension in your Data Pane, named something like Sub-Category (group).

Step 4: Edit and Refine the Group

The grouping logic remains the same. You'll probably want to rename the auto-generated group members. To do this, find the new group dimension in your Data Pane, right-click it, and select Edit Group.... This will open the same dialog box from the previous method, where you can rename your new combined category to something more meaningful, like 'Office Consumables', and continue grouping other items.

Useful Grouping Techniques and Pro Tips

Once you've mastered the basics, here are a few other tips to make grouping even more powerful.

Using "Find" for Quicker Selections

If your dimension has hundreds of members, scrolling to find them is a pain. In the 'Create Group' dialog box, use the Find Members search bar. For example, if you wanted to group all laptop products, you could search for "laptop" to quickly find and select all relevant members.

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

When to Use a Calculation Instead of a Group

While groups are fantastic for quick, manual categorizations, they are static. If new data comes in that should belong to an existing group, you'll have to edit the group and add it manually. For dynamic or rule-based categorizations, a Calculated Field is often a better choice.

Imagine you want to categorize products as 'High Price' or 'Low Price' based on their average price.

• A Group is not ideal for this, as prices can change.
• A Calculated Field with an IF statement (e.g., IF [Price] > 100 THEN "High Price" ELSE "Low Price" END) automatically categorizes every product based on a logical rule, and it will update as your data changes.

To create rule-based text categories, CASE statements are excellent. For instance, to group products based on keywords in their names:

CASE TRUE
WHEN CONTAINS([Product Name], "Shirt") THEN "Tops"
WHEN CONTAINS([Product Name], "Pants") THEN "Bottoms"
WHEN CONTAINS([Product Name], "Jacket") THEN "Outerwear"
ELSE "Other"
END

General Rule of Thumb: Use a Group for manual, named lists of things that won't change often. Use a calculated field when you can define categories based on a repeatable rule or logic.

Final Thoughts

Being able to group dimension members is a fundamental skill in Tableau that transforms cluttered charts into clear, strategic dashboards. Whether you use the Data Pane for precise control or the visual grouping method for quick analysis, creating categories helps you summarize information and find more meaningful stories in your data.

This process of cleaning and categorizing data is a necessary step in almost every reporting workflow, but it often feels like prep work keeping you from the actual insights. At Graphed, we automate this entire reporting layer by connecting directly to your sources like Google Analytics, Shopify, and Salesforce. Instead of manually selecting and grouping dimensions, you can simply ask in plain language, "Show me last month's sales by region," and our AI will instantly build the dashboard for you, grouping the data correctly behind the scenes and letting you get straight to the answers.