How to Group Fields in Power BI

Got a Power BI chart so crowded with categories it’s impossible to read? This common problem turns a promising visualization into a source of frustration, leaving you and your audience struggling to find any real meaning. Thankfully, Power BI has a straightforward feature designed to solve this: grouping.

Graphed

Still Building Reports Manually?

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

Watch the Demo

This tutorial will walk you through exactly how to use grouping in Power BI to organize your data into logical categories. We'll cover how to group both text-based fields and numerical data (a process often called binning), turning your detailed, messy charts into clean, high-level summaries that tell a clear story.

What is Grouping in Power BI (and Why Should You Care)?

Grouping is the process of combining multiple individual values from a field into larger, more meaningful categories. Instead of displaying every single data point on an axis, you bundle them together to see the bigger picture. It’s an essential technique for both data cleaning and effective storytelling in your reports.

Imagine you have sales data for every city in the United States. Plotting each city on a bar chart would be completely unreadable. By grouping, you could combine them into logical regions like "Northeast," "West Coast," or "Southeast," instantly making the chart useful for high-level analysis.

Key Benefits of Grouping Data

• Reduces Visual Clutter: It’s the fastest way to clean up over-populated charts, graphs, and tables. Fewer data points on a visual make it easier to interpret at a glance.
• Enables High-Level Analysis: Grouping lets you step back from the granular details to identify broader trends. Comparing sales performance by "Product Category" is often more insightful than comparing every single individual product.
• Improves User Experience: Dashboards that feature grouped data are more intuitive for your stakeholders. It allows them to start with a summary view and, if you set up hierarchies, drill down into details as needed.
• Creates Custom Categories On-the-Fly: You don't always need to go back to your source data or ask an engineer to create new columns. Grouping allows you to create new categorical logic directly within your Power BI report.

How to Create Groups in Power BI (Step-by-Step)

The method for grouping differs slightly depending on whether you're working with text (categorical data) or numbers (continuous data). Let’s start with the most common scenario: grouping text fields.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Grouping Text or Categorical Data

Let's use a practical example. Say you have a dataset with a list of countries, and you want to analyze performance by sales territory: "North America," "Europe," and "Asia." Here’s how you’d do it:

Step 1: Locate and Select Your Field In the Data pane on the right-hand side of Power BI Desktop, find the field you want to group. In our example, this would be the "Country" field. Right-click on it.

Step 2: Create a New Group From the context menu that appears, click on New group. This will open the Groups dialog box.

Step 3: Define Your First Group You'll see a window with a list of "Ungrouped values," which are all the individual entries in your "Country" field. To create your first group, hold down the Ctrl key and click to select all the countries you want in your "North America" territory (e.g., "United States," "Canada," "Mexico"). With those values selected, click the Group button underneath the list.

Step 4: Rename the Group Power BI will create a new group in the "Groups and members" box and give it a default name (like "United States &..."). This isn't very descriptive, so double-click on the group name and rename it to something clear, like North America.

Step 5: Repeat for Other Groups Now, go back to the "Ungrouped values" list and repeat the process for your other territories. Select your European countries, click Group, and rename the new group to Europe. Do the same for your Asian countries and name it Asia.

Step 6: Handle the Remaining Values At the bottom of the window, you'll see a checkbox labeled Include Other group. This is an incredibly useful option. If you check it, Power BI will take all the values you didn't add to a group and automatically lump them together into a group called "Other." This is great for catching typos, newly added countries, or any data you intentionally want to separate from your main categories. For now, let's keep it checked.

Step 7: Finalize and Use Your Group Click OK. Power BI will create a new field in your Data pane called "Country (groups)" (or whatever your original field was named plus "(groups)"). You'll notice it has a different icon. You can now drag this new field into any visual just like you would with any other field. For instance, dragging "Sales" and "Country (groups)" into a bar chart will give you a clean comparison between North America, Europe, Asia, and Other.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Grouping Numbers and Dates: Creating Bins

Grouping numerical data is a bit different. Instead of manually selecting individual values, you define ranges or "bins" to segment your data. This is perfect for things like creating age brackets, pricing tiers, or histograms.

Let’s say you have product sales data and you want to group products by their price to see which price ranges are most popular.

Grouping Numeric Data (Creating Bins)

Step 1: Select Your Numeric Field Go to the Data pane, right-click on your numeric field (e.g., "Price"), and select New group.

Step 2: Choose Your Grouping Method (Binning) Since you selected a numeric field, the Groups window looks different. You'll have an option for "Group type." The default is often "Binned." Make sure it's selected. Here, you have to decide how you want to create your ranges:

• Bin size: You specify the size of each bucket. For example, if you enter 100, Power BI will create groups of $0-$100, $101-$200, $201-$300, and so on. This is great when you know the ideal interval size for your analysis.
• Number of bins: You tell Power BI how many total groups you want. For instance, if you enter 5, Power BI will look at your minimum and maximum prices and automatically divide that range into five equal buckets. This is useful when you just want a quick high-level distribution.

For our example, let's choose Bin size and set it to 50. This will create price brackets like 0-50, 50-100, 100-150, etc.

Step 3: Create and Use the Binned Field Click OK. A new field named "Price (bins)" will appear in your Data pane. Now you can use this field to create insightful visuals. For example, a histogram using "Price (bins)" on the axis and "Order Count" as the value would instantly show you the distribution of your sales across different price points.

Practical Tips for Effective Grouping

Creating groups is easy, but using them effectively requires a bit of thought. Here are a few tips to get the most out of this feature.

Tip 1: Use Groups to Create a Drill-Down Hierarchy

One of the most powerful ways to use groups is to create hierarchies. This allows you and your report viewers to start with a summary view and drill down into the details.

To do this, simply drag the original, ungrouped field directly underneath your new grouped field in the "Fields" area of a visualization. For our country example, you could drag the original "Country" field under your "Country (groups)" field.

Now, your chart will show the grouped territories, but you can click a button to expand a territory (e.g., "North America") and see the individual-level data for just the countries within that group ("United States," "Canada," "Mexico").

Graphed

Still Building Reports Manually?

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

Watch the Demo

Tip 2: Easily Edit Your Existing Groups

Your data or analysis needs can change. You don't have to start from scratch if you need to adjust a group. Just go to the Data pane, find your grouped field, right-click it, and select Edit group. The Groups window will pop up with all your settings preserved, allowing you to move items between groups, rename them, or change your binning logic.

Tip 3: Name Your Groups Clearly

The names of your groups become the labels in your charts and tables, so clarity is important. Avoid generic names like "Group 1" and "Group 2." Instead, use descriptive names that explain the logic behind the category (e.g., "High-Value Customers," "Under $50," "West Coast Region"). This makes your reports instantly understandable without requiring extra explanation.

Final Thoughts

Grouping in Power BI is a fundamental skill that transforms cluttered data into clean, comprehensible visuals. By logically segmenting categorical fields and binning numerical data, you can create summary reports that tell a clear story, providing high-level insights that would otherwise be lost in the noise.

While features like grouping give you great manual control in traditional BI tools, the entire process of cleaning, organizing, and visualizing data still takes time. At Graphed, we've focused on automating that entire workflow. We allow you to connect all your marketing and sales data sources and simply ask for what you need in plain English. Instead of manually clicking to create groups and building charts, you can ask, “Show me sales per region for the last 3 months,” and we build the interactive dashboard for you, completely skipping the learning curve and helping you get to actionable insights fast.