How to Create Categories in Power BI

Wrangling raw, messy data into clean, understandable categories is one of the most common challenges when building a Power BI report. You might have a list of 200 individual products you want to see as "Apparel" vs. "Electronics," or a column of fifty states you need to group into "West Coast," "Midwest," and "Northeast." This article will walk you through a few different ways to create these categories, from simple point-and-click methods to more powerful, flexible formulas.

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

Why Bother Creating Categories in Power BI?

Before jumping into the "how," it's helpful to understand "why." Grouping data isn't just about making things look tidy, it allows you to see the bigger picture. Imagine trying to analyze sales performance across all 50 U.S. states on a single bar chart. It would be an overwhelming, unreadable mess of tiny bars.

But what if you grouped them into four regions? Suddenly, you have a clean, insightful chart that clearly shows which region is driving the most revenue. Creating categories helps you:

• Simplify visualizations: Reduce clutter and make charts easier to interpret at a glance.
• Improve analysis: Compare performance between high-level segments instead of getting lost in the details.
• Tell a clearer story: Guide your audience's attention to the most important trends in your data.

Let's look at the best ways to get this done in Power BI.

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 1: The Quick and Easy Way – Grouping in Visuals

This is the fastest method for ad-hoc analysis. If you're exploring data and just want to quickly combine a few items on a chart to see how they look, visual grouping is perfect. The key thing to remember is that this group only exists for the specific visual you create it in.

Let's say you have a bar chart showing sales by product, and you want to group a few low-performing items into an "Other" category.

Step-by-Step Instructions:

1. Create your chart (e.g., a bar chart showing Sales by Product Name).
2. Hold down the Ctrl key on your keyboard.
3. Click on the data points (the bars, in this case) that you want to include in a group. In our example, you'd click on the bars for "Basic T-Shirt," "V-Neck T-Shirt," and "Crewneck Sweatshirt."
4. With them selected, right-click on one of the selected bars.
5. From the context menu, select Group.

Instantly, Power BI will combine those selected bars into a single new bar, and a new "(group)" field will appear in the visual's legend. You can do this multiple times within the same visual to create several different groups.

Best for: Quick analysis, creating simple "Other" categories, and experimenting with groupings without changing your underlying data model.

Limitation: The group you create cannot be used in any other visuals. If you need a reusable category, you’ll need Method 2.

Method 2: Creating Reusable Groups from the Fields Pane

When you have a category you know you'll want to use across multiple charts and tables in your report, this is the way to go. This method creates a new column in your data table that you can drag and drop into any visual, just like any other field.

Let's use the example of grouping U.S. states into sales regions.

Step-by-Step Instructions:

1. In the Fields pane on the right side of the screen, find the field you want to group (e.g., "State").
2. Right-click on the "State" field.
3. Select New group from the menu.
4. The "Groups" window will pop up. Give your new group field a clear name at the top, like "Sales Region."
5. You'll see a list of all your ungrouped values. Hold down the Ctrl key, select all the states for your first region (e.g., "Washington," "Oregon," "California"), and then click the Group button.
6. Double-click the default name ("Washington & Oregon & California") and rename it to something clean, like "West Coast."
7. Repeat this process for all your other regions ("Midwest," "Northeast," etc.).
8. You can optionally check the box for Include Other group to automatically catch any values you didn't manually assign to a group.
9. Click OK.

You will now see a new field called "Sales Region" in your Fields pane, indicated by a small grouping icon. You can use this field anywhere in your report.

Best for: Creating formal, report-wide categories that need to be used in multiple visuals and slicers.

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 3: Categorizing Numbers with Binning

Grouping text fields is useful, but what about continuous numbers, like customer age or product price? You might want to analyze performance across age brackets or price tiers. This is where "binning" comes in.

Binning is simply Power BI's term for grouping a range of numerical values into a small number of "bins."

Step-by-Step Instructions:

1. In the Fields pane, find the numeric field you want to categorize (e.g., "Order Total").
2. Right-click the field and select New group.
3. In the "Groups" window, Power BI automatically recognizes it's a number field and shows the Binning options instead of the list grouping. From the "Group type" dropdown, make sure Bin is selected.
4. Now, choose your "Bin type":
5. Click OK.

As with Method 2, this creates a new field (e.g., "Order Total (bins)") that you can now use to see, for instance, which price category generates the most sales.

Best for: Segmenting customers by age, classifying products by price ranges, or analyzing deal sizes.

Method 4: The Power User's Approach – Using DAX Formulas

For the ultimate flexibility and control, you can create categories using DAX (Data Analysis Expressions). This sounds more intimidating than it is. Using a formula allows you to build custom logic that simple grouping can't handle. For example, "If a sale is over $500 and the product category is 'Electronics,' then label it as 'High-Value Tech Purchase'."

You create DAX-based categories by adding a "New Column" to your data table.

Using the SWITCH Function

The SWITCH function is often the cleanest way to set up categories with multiple conditions. It checks a value against a list and returns a result accordingly. Let's create sales tiers based on the sale amount.

Steps:

1. Go to the Data View (the table icon on the left).
2. Select the table you want to add the column to.
3. From the "Table tools" ribbon at the top, click New column.
4. Enter the following formula into the formula bar:

Sale Tier = 
SWITCH(
    TRUE(),
    'Sales'[SaleAmount] < 100, "Small",
    'Sales'[SaleAmount] < 500, "Medium",
    'Sales'[SaleAmount] < 2000, "Large",
    "Enterprise"
)

This DAX formula creates a new column called "Sale Tier." It checks the SaleAmount for each row and assigns it the appropriate label. The last value, "Enterprise," acts as the "else" condition, catching anything over $2,000.

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

Using the IF Function

For simpler, binary conditions, the IF function is a great choice. For example, let's categorize products as either "High Price" or "Regular Price" based on a $50 threshold.

Steps:

1. Follow the above steps to create another new column.
2. Enter this formula:

Price Category = 
IF(
    'Products'[Price] > 50, 
    "High Price", 
    "Regular Price"
)

Best for: Situations requiring conditional logic, categorizing based on multiple fields, or creating highly customized business rules that can't be handled by the point-and-click grouping tools.

Final Thoughts

Turning messy data points into clean categories is a foundational skill in Power BI that elevates your reports from confusing to clear. Whether you use a quick visual group for exploration, a reusable group for consistency, or a powerful DAX formula for custom logic, organizing your data makes it infinitely easier to find and share meaningful insights.

While setting up these categories is a crucial step, we know it's just one part of the wider reporting process, which often involves hours of manual setup. At Graphed, we built our tool to skip right past the manual drudgery. Instead of learning DAX expressions or clicking menus to group data, you can simply ask for what you need in plain English - like "show me sales by region" or "compare revenue from high price vs regular price items" - and get back a real-time dashboard instantly. All your data lives in one place, so you can focus on making decisions, not on report-building.