How to Create Groups in Power BI

Cleaning up a messy chart in Power BI often comes down to one powerful feature: grouping. When your visuals are cluttered with too many individual categories or your numeric data is too granular, grouping helps you consolidate that information into meaningful, easy-to-read clusters. This article will walk you through the two main methods for creating groups in Power BI so you can simplify your reports and tell a clearer story with your data.

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 Should You Group Data in Power BI?

Before we jump into the "how," let's quickly cover the "why." Grouping isn't just about making things look prettier, it's a fundamental analysis technique that brings several benefits to your reports:

• Improves Readability: A bar chart with 50 individual bars is confusing. A chart showing 5 well-defined groups is instantly understandable. Grouping declutters your visualizations so your audience can grasp the main point immediately.
• Simplifies Complex Data: If you have dozens of product categories, an endless list of sales reps, or survey responses with minor variations, grouping them into logical buckets (like "Top Products," "East Region Team," or "Positive Feedback") makes the data manageable.
• Reveals Higher-Level Trends: Sometimes, insights are hidden in the aggregate. By grouping individual data points - like grouping daily sales figures into weeks or individual ages into age brackets - you can spot patterns that weren't visible at a granular level.
• Creates Custom Categories On-the-Fly: You don't always need to go back to your source data or write complex DAX formulas to create new categories. Grouping allows you to create these segments directly within the Power BI report view.

Method 1: Grouping Categorical Data (List Grouping)

List grouping is the most common method, and you'll use it for text-based, or categorical, fields. Think of columns like Product Name, Country, Salesperson, or Campaign Source. You'll essentially hand-pick items from a list and bundle them together into a new group.

Let's use a common scenario: you have a sales report with dozens of countries, but you want to see performance by continent or sales territory. Some countries contribute very little to sales, cluttering your chart.

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-by-Step Guide to List Grouping:

1. Find and Right-Click Your Field

Go to the Data pane on the right-hand side of Power BI. Find the data field you want to group (in our example, it's 'Country'). Right-click on the field name and select New group from the context menu.

2. Create Your First Group

A "Groups" dialog box will appear. You'll see a list of all the individual values from your chosen field in the "Ungrouped values" box.

To create your first group, select the items you want to bundle together. You can select multiple items by holding down the Ctrl key while you click. In our example, let's select "United States" and "Canada."

With those items selected, click the Group button.

3. Rename the Group Immediately

Your selected items will now appear under a new group in the "Groups and members" list on the right. Power BI will give it a default name based on the items you selected, like Canada & United States (group). This isn't very helpful.

Immediately double-click on that new group name and give it a clear, intuitive label like "North America." Good naming is crucial for anyone who has to read your report.

4. Fleshing Out the Rest of Your Groups

Now, repeat the process. Go back to the "Ungrouped values" list, select all the European countries you need (e.g., "Germany," "France," "United Kingdom"), click Group, and rename the new group to "Europe."

Continue this process until you've bucketed your most important categories into logical groups. But what about all the leftover values?

5. Dealing with Leftovers: The "Other" Group

You’ll often have many "long-tail" items that are too small to have their own group and just create noise. This is where the "Other" group comes in handy. It's one of the most useful features that beginners overlook.

At the bottom of the dialog box, you'll see a checkbox labeled Include Other group. Check this box to automatically lump all remaining ungrouped values into a single category named "Other." This is perfect for cleaning up pie charts or bar graphs and focusing attention on the most significant segments.

6. Finish and Use Your New Grouped Field

Once you are happy with your setup, click OK. Power BI will create a brand new field appearing in your Data pane with its name appended by (groups). In our case, there will now be another dimension in that table "Country - (Groups)" which has those custom values - "Europe, North America, Other."

Now, you can use this new field just like any other column in your data model. Drag it onto a chart visual to see your data aggregated by the clean, simple groups you created. You'll see a much simpler and more insightful visualization.

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: Grouping Numerical Data (Binning)

What if your data isn't text-based categories but a continuous range of numbers, like Age, Price, Revenue, or Order Size? Attempting to plot hundreds of unique price points on a chart would be impossible to read. The solution is binning, which is Power BI's term for grouping numerical values into ranges or "bins."

This is extremely useful for creating histograms or analyzing distributions. For example, you could group customers into age brackets (20-29, 30-39, etc.) or products into price ranges ($0-$50, $51-$100, etc.).

Step-by-Step Guide to Binning:

1. Select Your Number Field

Just like before, go to the Data pane, but this time, right-click on the numerical field you want to group. For this example, we’ll use a product ‘Price’ field. Select New group.

2. Choose Your Grouping Method

The "Groups" dialog box for numerical fields looks different. The "Group type" dropdown will give you two options: "Bin" or "List." Since we're working with continuous numbers, Power BI assumes we want "Bin," which we do.

Under "Bin type," you have two main choices for defining your ranges:

• Size of bins: This lets you set a fixed size for each range. For example, if you set the bin size to 50 for our 'Price' field, Power BI will create groups like $0-$50, $50-$100, $100-$150, and so on. It automatically looks at the minimum and maximum values in your data to create the appropriate number of bins. This is great when you know the logical range you want to use.
• Number of bins: This tells Power BI how many total groups you want. If you set the number of bins to 4, Power BI will divide the entire range of your data (from min to max) into four equal-sized groups. This is useful when you want to quickly break your data into quartiles, quintiles, deciles, etc., and don't care about the specific ranges.

3. Configure Your Bins

Let's choose Size of bins and set the value to 100. This will group our products into price buckets based on hundred-dollar increments. A "min val" and "max val" are detected at a glance which ensures you know the range your data has.

4. Finalize and Use Your Bins

Click OK. A new field named '[YourField] (bins)' (e.g., 'Price (bins)') will be created in your Data pane.

Now you can build new visuals. For example, drag the new 'Price (bins)' field to the Axis of a bar chart and a count of 'Product ID' to the Values. Just like that, you've created a histogram showing how many products fall into each price range, providing a clear view of your product pricing distribution.

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

Editing and Managing Your Groups

Your work isn't set in stone. Your business logic or analytical needs may change over time, requiring you to modify your groups.

To edit any group or bin you’ve created, simply find the grouped field in your Data pane, right-click on it, and select Edit group. The same dialog box will appear, allowing you to:

• Rename groups.
• Move items from one group to another.
• Add ungrouped items to an existing group.
• Adjust the bin size or number of bins for numerical data.

This flexibility makes groups a low-commitment, high-reward feature for cleaning up your data on the fly.

Final Thoughts

Mastering both categorical grouping and numerical binning in Power BI lets you transform dense, cluttered data into clear, actionable reports. By consolidating items into logical categories or ranges, you can clean up visualizations, simplify your analysis, and help your stakeholders focus on the insights that truly matter.

While Power BI's built-in tools are great, the process of preparing data, building visuals, and creating groups manually can still be a multi-step process. This is precisely why we created Graphed. Instead of clicking through menus and dialog boxes, you can just tell our AI data analyst what you want in plain English. For example, ask "show me sales by product, grouping the top 5 products and bucketing the rest as 'Other'," and we instantly generate the interactive dashboard for you, connected directly to your live data sources.