How to Ungroup in Power BI

You've grouped data together in a Power BI visual to see the bigger picture, maybe to compare your top-performing products against everything else. But now, it's time to drill back down into the details. This guide will walk you through exactly how to ungroup data in Power BI, whether it's in a specific visual or within your broader data model.

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

First, Why Do We Group Data in Power BI?

Grouping is a simple yet powerful feature in Power BI. It allows you to combine multiple data points into logical categories on the fly, directly within a report. This is incredibly useful for ad-hoc analysis without having to create complex formulas in DAX or modify the source data in Power Query.

Common reasons to group data include:

• Creating High-Level Categories: Bundling dozens of individual products into categories like "Best Sellers" and "Other."
• Segmenting Data: Grouping sales territories into larger regions like "North America" or "Europe."
• Binning numbers: Categorizing customer ages into ranges like "18-25," "26-35," etc., for clearer analysis in charts (a feature Power BI calls binning).
• Consolidating "Other" values: Cleaning up a chart by grouping all the small, miscellaneous data points into a single "Other" category to improve readability.

Grouping helps transform a messy, granular visual into a clean, insightful summary. But inevitably, you'll need to reverse the process to explore the underlying details again.

Visual Grouping vs. Data Model Grouping: What's the Difference?

Before ungrouping, it's essential to understand where the grouping was created. Power BI offers two primary ways to group data, and the method to 'ungroup' depends on which one was used.

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

1. Grouping Within a Specific Visual

This is the most common method. You select data points directly on a chart (e.g., by holding Ctrl + Click on several bars in a bar chart), then right-click and select "Group."

• Scope: This group only exists within that single visual. It won't appear on any other charts or in your Fields pane.
• Use Case: Ideal for quick, one-off analyses on a specific chart without cluttering your data model.

2. Grouping in the Fields Pane (Data Model Group)

This method involves selecting a field in the "Fields" pane on the right, right-clicking it, and choosing "New group." This creates a new field in your data model, which you can see in the Fields list, often with "(group)" appended to its name.

• Scope: This new grouped field is part of your data model and can be reused across any visual on any page in your report.
• Use Case: Perfect for creating standardized categories (like sales regions or product tiers) that you plan to analyze consistently across your entire report.

Knowing this distinction is key. Are you trying to ungroup elements on just one chart, or are you trying to remove a custom category field that appears everywhere? Let's tackle both scenarios.

How to Ungroup Data in a Power BI Visual (Step-by-Step)

Let's say you have a bar chart showing scooter sales by city. You previously grouped several cities into a "Top Cities" group for a presentation and now want to revert the chart to show all individual cities again. This is how you ungroup it.

There are two quick ways to do this:

Method 1: Using the Visualizations Pane

This method is clear and works for all visual types.

1. Select the Chart: Click on the visual in your report that contains the grouped data.
2. Locate the Grouped Field: In the "Visualizations" pane on the right, look at the fields you've added. The grouped field is typically in the "Axis" or "Legend" well and will have "(groups)" as part of its name. For example, if you grouped the 'City' field, you'll see a field named City (groups).
3. Open the Menu: Hover over the grouped field and click the ellipsis (...) that appears.
4. Select Ungroup: From the dropdown menu that appears, simply click "Ungroup."

Your chart will instantly refresh and display the original, ungrouped data points. The City (groups) field will disappear from the Visualizations pane, and your original City field will take its place.

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: Right-Clicking the Visual

For even faster ungrouping, you can do it directly on the chart.

1. Select the Visual: Click to activate your chart.
2. Right-Click a Grouped Element: Right-click on one of the grouped elements in the chart itself, such as the "Top Cities" bar.
3. Choose Ungroup: In the context menu that pops up, select "Ungroup." This will dissolve all the groups within that visual simultaneously.

How to Remove a Group from Your Data Model (Fields Pane)

If your group was created as a new field in the data model, ungrouping works a bit differently. In this case, you aren't just ungrouping in a visual — you're deleting the grouped field from your entire report.

You'd do this if the group is outdated, was made in error, or has been replaced by an official category coming from the data source.

1. Go to the Fields Pane: Look at your list of data tables and fields on the far right of your workspace.
2. Find the Grouped Field: Locate the field you want to remove. It will have a special grouping icon next to it and likely end with "(group)."
3. Right-Click and Delete: Right-click on the group name to open the context menu.
4. Select "Delete from model": Choose this option. Power BI will show a warning dialogue, notifying you that deleting this field will break any visuals that are currently using it. If you're certain, click "OK."

Once deleted, the group will be completely removed from your data model and will need to be recreated if you need it again.

Should You Ungroup or Just Edit the Group?

Sometimes, all you need is a small adjustment. Rather than completely ungrouping everything and starting over, you might just need to edit the existing group.

For example, what if a new city needs to be added to your "Top Cities" group? Instead of ungrouping, just edit:

1. Find your group in the Fields Pane (this works for both types of groups).
2. Right-click the group and choose "Edit groups."
3. The Groups editor will open. Here, you can move items from the "Ungrouped values" list into an existing group, move items between groups, or rename the groups themselves.

Editing is far more efficient if the overall structure of your groups is still correct and you just need to make minor changes.

Troubleshooting Common Grouping Issues

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

Why is the "Ungroup" Option Grayed Out or Missing?

If you right-click a visual and can't find the "Ungroup" option, it's almost always because the grouping was created in the data model (Fields pane), not on the visual itself. To remove it, you must follow the steps to "Delete from model" described earlier.

"I Deleted a Group and Now Half My Report Is Broken!"

This classic issue happens when you delete a group from the data model that was used in multiple visuals. Power BI warns you about this for a reason. Before deleting a group from the Fields pane, quickly scan your report to see where it's being used. Be prepared to reconfigure those visuals with the original, un-grouped field once it has been deleted.

Final Thoughts

Ungrouping in Power BI is a simple task once you identify whether the group lives in a single chart or across your whole data model. By following the right steps, you can easily toggle between a high-level summary and a detailed view, making your reports more flexible and insightful.

While Power BI is incredibly capable, managing these granular steps for every chart can add up. We built Graphed because we believe getting insights shouldn't require navigating endless menus and panes. Instead of manually clicking to group products, you can simply ask, "show me a comparison of my top 5 products vs. the rest," and the visual appears instantly. To go back to the details, you just ask. We automate the technical process so you can stay focused on what the data is telling you, not on the clicks it takes to find out.