How to Group Multiple Columns in Power BI

Wrangling multiple columns of data into clean, insightful groups doesn't have to be a headache. Whether you need to combine location data, categorize products, or create custom segments, Power BI has several flexible ways to get it done. This tutorial will walk you through the most effective methods for grouping multiple columns, from transforming your data at the source to creating quick calculations on the fly.

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 Grouping Columns in Power BI?

Before jumping into the "how," let's quickly cover the "why." Combining columns isn't just about tidying up your data model, it directly impacts the usability and clarity of your reports. Imagine you have separate columns for Product Category, Sub-Category, and Brand. Analyzing them individually is clunky. Grouping them creates a single, clean "Product Hierarchy" for much simpler visuals.

Here are the core benefits of grouping data:

• Simplifies Your Visuals: Tables and charts are much easier to understand when you consolidate related information. Showing sales by a single "Location" column (e.g., "Seattle, WA") is cleaner than displaying two separate "City" and "State" columns.
• Enhances Report Readability: Fewer columns mean less scrolling and a less cluttered report canvas. Your end-users can find what they need faster.
• Creates Usable Hierarchies: You can create parent-child relationships that allow users to drill down in your reports, for instance, from Country > State > City, all managed through a well-structured group.
• Makes DAX Easier: Sometimes, grouping columns first can significantly simplify the DAX (Data Analysis Expressions) formulas you need to write for your measures and reports later on.

Method 1: Grouping with the Power Query Editor

The Power Query Editor is the best place to perform most of your data cleaning and transformation tasks, including grouping. Why? Because these changes are applied to your data before it's loaded into the data model. This keeps your model cleaner, often improves performance, and ensures your groupings are consistent across your entire report.

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

Grouping by Merging Columns

Merging is the most straightforward way to group columns. It combines the text values from two or more columns into a single new column, perfect for creating things like a full name, a complete address, or a product identifier.

Let’s say you have marketing campaign data with separate columns for 'Campaign Source' and 'Campaign Medium.' Combining them will help you see performance more clearly.

Step-by-Step Instructions:

1. From the Home ribbon in Power BI Desktop, click on Transform data. This will open the Power Query Editor.
2. In the preview window, find the columns you want to combine. Hold down the Ctrl key and click on each column header to select them. The order you select them in is the order they will appear when merged.
3. With the columns selected, navigate to the Add Column tab at the top of the window.
4. In the "From Text" section, click on Merge Columns.
5. A popup dialog will appear. Here you can configure your new merged column:
6. Click OK. You'll now see your new, merged column at the right end of your table.
7. When you're finished with all your transformations, go to the Home tab and click Close & Apply.

Grouping with Conditional Columns for Custom Categories

Sometimes grouping isn’t about joining text together, it's about creating new categories based on the values in existing columns. This is where Conditional Columns become incredibly useful. You can use them to create logical buckets, like grouping sales deals into "Small," "Medium," or "Large" based on their value, or classifying campaigns by performance tiers ('High Performer', 'Average', 'Underperformer') based on ROI.

Let's create a custom "Deal Size" category based on the value in a deal_amount column.

Step-by-Step Instructions:

1. In the Power Query Editor, go to the Add Column tab again.
2. In the "General" section, click on Conditional Column.
3. The Conditional Column dialog box is where you build your grouping logic using simple if/then statements:
4. Click OK. A new column will be added that categorizes every row based on the rules you just defined.
5. Click Close & Apply to load the new grouped column into your report.

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: Creating Groups with DAX in the Report View

What if you’ve already loaded your data and don't want to go back into the Power Query Editor? Or perhaps you need more complex, formula-based logic for your groups. In this case, you can use DAX to create a new "calculated column" directly in the report view.

Using a Calculated Column for Grouping

A calculated column feels similar to adding a new column in Power Query, but its calculation happens within your data model after loading. It's fantastic for quick additions or when your grouping logic depends on relationships between tables.

Simple Grouping with CONCATENATE

This is the DAX version of "Merge Columns" in Power Query. Let's merge First Name and Last Name columns from a customer table.

1. In the main Power BI window, click on the Data view (the table icon) on the left sidebar.
2. Select the table you want to add the column to from the Fields pane on the right.
3. From the Table Tools ribbon at the top, click New column.
4. The DAX formula bar will appear. Enter your formula. To combine the first and last names with a space in between, you would type:
5. Press Enter. The new "Full Name" column will appear in your table.

The & symbol is the concatenation operator in DAX, and whatever you put in double-quotes is treated as a literal text string.

Advanced Logical Grouping with DAX's SWITCH Function

For more advanced, logic-based grouping similar to the Conditional Column example, DAX provides powerful functions like IF and SWITCH. The SWITCH function is often cleaner and easier to read for multiple conditions.

Let's recreate the "Deal Size Category" using DAX:

Step-by-step:

1. Follow steps 1-3 from the previous example to create a new calculated column in your sales table.
2. In the DAX formula bar, enter the following logic:

Deal Size Category DAX =
SWITCH(
    TRUE(),
    Sales[Deal Amount] > 10000, "Large Deal",
    Sales[Deal Amount] > 5000, "Medium Deal",
    "Small Deal"
)

1. Press Enter. This formula evaluates each condition from top to bottom. The first one that returns TRUE determines the value for that row. If none are true, it returns the final "else" value ("Small Deal").

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

Best Practices: Which Grouping Method Should You Use?

You have several options, so which one is best? Here’s a quick guide to help you decide:

• Use Power Query (Method 1) when...
• Use DAX Calculated Columns (Method 2) when...

Final Thoughts

Grouping multiple columns is a fundamental skill for moving beyond basic reporting in Power BI. By consolidating related data - either by merging columns in Power Query or by writing logical DAX formulas - you make your reports cleaner, your visuals more impactful, and your data easier for everyone to understand. Choose the method that best fits your workflow, but always aim to push transformations upstream into Power Query when possible.

Manually building reports, even with powerful tools like Power BI, can still feel like you're stuck in data-wrangling mode. We created Graphed to remove this friction entirely. Instead of clicking through menus to merge columns or writing formulas, you can just ask in plain English, "Show my sales by region and combine the city and state columns," and our tool builds the visual for you instantly, connecting directly to your live data sources.