How to Group Items in Power BI

Grouping data in Power BI is a simple way to combine different values into a single, organized category. Instead of looking at a list of 50 individual states, for instance, you can bundle them into meaningful regions like "West Coast" or "Northeast." This article will walk you through how to create these groups for both text-based categories and numerical data, making your reports cleaner and easier to understand.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Group Items in Power BI?

Before getting into the step-by-step process, it's helpful to understand why grouping is such a useful feature. At its core, grouping transforms cluttered data into clear, high-level insights. It helps you tame complexity and tell a more focused story with your visuals.

Here are a few key benefits:

• Simplify Complex Data: If your dataset contains dozens or even hundreds of sub-categories, a standard bar chart or pie chart would be unreadable. Grouping allows you to consolidate these smaller items into a few manageable categories, making your visualizations instantly more effective. For example, grouping 100 different product SKUs into broader categories like "Electronics," "Apparel," and "Home Goods."
• Enhance Data Analysis: By creating custom segments, you can analyze your data from new angles. You might group sales transaction values into "Small," "Medium," and "Large" buckets to see which transaction size contributes the most revenue. This is a level of analysis that wasn't possible with the raw, ungrouped data.
• Create Custom Hierarchies: Often, the categories you need for your report don't exist in your original data source. Grouping lets you invent them on the fly directly within Power BI. You can define sales territories, customer segments, or product tiers without having to go back and modify the underlying spreadsheet or database.
• Improve Readability: A dashboard that shows "Top 5 Sales Regions" is much easier to digest than one that lists "Top 50 Individual Cities." Grouping helps your audience focus on the big picture without getting lost in the details.

How to Group Categorical Data (Text Fields)

Grouping categorical (text) data is the most common use case. It’s perfect for organizing things like products, countries, store names, or marketing channels.

Let’s use a practical example. Imagine you have sales data for every US state, and you want to see performance by region - West Coast, Midwest, and Northeast. Your original dataset only has a "State" column, not a "Region" column. Here’s how you’d create it using grouping.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step-by-Step Instructions

Follow these steps to create your first group:

1. Select the Field to Group

In the Fields pane on the right side of the Power BI window, find the field you want to group. In our example, this would be the ‘State’ field. Right-click on it and select New group from the context menu.

2. Create Your First Group

This opens the Groups dialog box. You'll see two main sections:

• Ungrouped values: This list contains all the individual unique values from your selected field (e.g., 'California', 'Arizona', 'New York').
• Groups and members: This is where your newly created groups will appear.

To create your "West Coast" region, you'll select the relevant states from the 'Ungrouped values' list. Hold down the Ctrl key and click on 'California', 'Oregon', and 'Washington'.

With those three states selected, click the Group button underneath the list. A new group will appear in the 'Groups and members' box, likely with a default name like "California & Oregon & Washington".

3. Rename the Group

The default name isn't very helpful. Double-click on the new group in the 'Groups and members' box and rename it to something more descriptive, like "West Coast".

4. Create Additional Groups

Now, repeat the process for your other regions. Go back to the 'Ungrouped values' list, use Ctrl+click to select the states for your "Midwest" region (e.g., 'Illinois', 'Ohio', 'Michigan'), click the Group button, and rename the new group to "Midwest". Do the same for your "Northeast" region.

5. Handling Remaining Values with the 'Include Other' Group

What about all the states you didn't include in a group? At the bottom of the dialog box, you'll see a checkbox labeled Include Other group. If you check this box, Power BI will take all remaining ungrouped values and bundle them into a single category named "Other."

This is extremely useful when you want to focus your analysis on specific segments while consolidating everything else. For example, if you only care about your top three regions, grouping the rest into 'Other' prevents them from cluttering your visuals. If you leave it unchecked, the ungrouped states will remain as individual items in your charts.

Once you’re finished, click OK.

6. Use Your New Group in a Visual

Back in your Fields pane, you'll see a new field called 'State (groups)' (or whatever your original field was named, with '(groups)' appended). This is your new grouping field!

You can now drag this 'Region' field onto a visual, like a bar chart or a map. When you add a measure like 'Sales', your visual will display the total sales for West Coast, Midwest, and Northeast, with all the individual state data neatly aggregated.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Group Numerical Data (Binning)

Grouping isn't just for text values, it's also incredibly powerful for numerical data like age, price, or quantity. This process is often called binning because you’re sorting numerical values into different "bins" or buckets.

For example, instead of seeing the sales for every single individual price point ($1.99, $2.05, $5.10), you could group them into price tiers like "$0-$25," "$26-$50," and "$51+". Similarly, you can create age demographics by binning a list of customer ages.

There are two primary ways to create bins in Power BI: by size or by a specific number of bins.

Grouping Numerics by Bin Size

This approach lets you define the size of each bucket. For example, you want every age group to span exactly 10 years.

1. Select the Numeric Field: In the Fields pane, right-click the numerical field you want to group, like "Customer Age," and select New group.
2. Configure the Bins: The 'Groups' window will appear, but with options tailored for numeric data. Make sure the Group type is set to 'Bin'.
3. Set the Bin Size: Under Bin size, enter the size you want for each bucket. If you want to create age brackets that are 10 years wide (e.g., 20-29, 30-39), you would enter 10 as the bin size. Power BI automatically detects the minimum and maximum values in your data and creates the bins accordingly.
4. Click OK: After clicking OK, a new field named 'Customer Age (bins)' will be created. You can drag this field into a histogram or bar chart to visualize the distribution - for instance, to see how many customers fall into each age bracket.

Grouping Numerics by Number of Bins

Sometimes you don't care about the specific size of each group, but you want a fixed number of bars in your chart. For example, you always want to see customer price sensitivity across four equal tiers, regardless of whether your products range from $10 to $100 or $50 to $5,000.

1. Select the Numeric Field: Right-click the field (e.g., 'Product Price') and select New group.
2. Choose the Bin Count: In the 'Groups' window, set the Group type to 'Bin'. Then, for the Bin type (or 'Bin by'), choose Number of bins.
3. Define the Number of Groups: In the Bin count field, enter the number of groups you want. For example, entering 4 will cause Power BI to take the entire price range (from the minimum value to the maximum value) and divide it into four equal-sized buckets.
4. Click OK: A new binned field is created. When you use this group in a chart, it will always show exactly four categories. This method is great for creating consistent high-, medium-, and low-tier analyses.

Tips, Tricks, and Best Practices

Once you get comfortable with the basics, a few extra tips can help you work more efficiently.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Editing an Existing Group

Your data needs can change, and you might need to adjust a group later. To do this, simply find your group field in the Fields pane (e.g., 'State (groups)'), right-click it, and select Edit group. This will open the same dialog box where you can add or remove items from groups, rename them, or change your binning settings.

Groups vs. DAX Calculated Columns

Grouping is a fantastic tool for quick and simple categorization. However, if your logic is more complex, you might need a DAX calculated column instead.

• Use Grouping for: Straightforward, manually-defined categories where you are selecting items from a list (e.g., states in a region).
• Use a DAX Calculated Column for: Conditional logic. For example, if you wanted to create sales tiers based on multiple conditions (e.g., if Sales > 10,000 and Profit > 20%, then 'Tier A'), you would need to use a DAX formula with an IF() or SWITCH() function. A calculated column offers far more flexibility for rules-based segmentation.

Performance Considerations

Grouping is handled efficiently by Power BI's engine and rarely causes performance issues. However, if you are working with a dataset containing millions of rows and creating a very high number of granular groups, you might see a slight lag. In such advanced scenarios, it can be more performant to define the groups earlier in the data modeling process, such as in Power Query or in the source database itself.

Final Thoughts

Grouping data is a fundamental skill in Power BI that quickly transforms complex datasets into clear, actionable reports. Whether you’re organizing text-based categories into logical segments or binning numbers into value tiers, it’s a direct path to uncovering more meaningful insights that might have been hidden in the noise.

Building dashboards often involves many steps like this, from connecting data and transforming it to creating the right set of visualizations. At Graphed , we’ve focused on simplifying that entire workflow. Rather than manually clicking through menus to create groups and build reports, you can connect your sources and just ask for what you want in plain English, like "Show me sales grouped by West Coast, Midwest, and Northeast regions." Our AI data analyst builds a live, interactive dashboard for you in seconds, automating the tedious parts so you can get to answers faster.