How to Bucket Data in Power BI

Wrangling raw, detailed data into something clean and understandable can feel like a chore. You have a spreadsheet with hundreds of individual customer ages or a long list of exact order values down to the cent, and trying to graph it is a mess. This is where bucketing in Power BI comes in, allowing you to group that granular data into meaningful categories that tell a clear story.

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

This tutorial will show you exactly how to do it. We'll cover two straightforward methods for creating data buckets in Power BI, so you can turn messy numbers into a clear, actionable report.

What Exactly is Data Bucketing (and Why Should You Care)?

Data bucketing, also known as grouping or binning, is the process of taking a continuous range of values and sorting them into a smaller number of "buckets" or intervals. Instead of looking at every single data point, you analyze them as consolidated groups.

Think of it like this: Instead of analyzing sales data by every individual customer's age (23, 47, 51, 33, 29...), you can group them into buckets that are much easier to work with:

• 18-24
• 25-34
• 35-44
• 45+

Suddenly, a chaotic list of numbers becomes a clean set of categories you can use in a chart. This simple act of grouping makes your reports instantly more readable and is crucial for uncovering hidden trends.

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

Common Examples of Data Bucketing in Business

This technique is incredibly useful across different departments:

• For E-commerce: Grouping order values into categories like "$0-$50," "$51-$100," "$101-$250," and "$250+" to identify your most valuable customer segments.
• For Marketing: Bucketing website session durations (e.g., "0-30 seconds," "31-120 seconds," "2+ minutes") to understand user engagement levels.
• For Sales: Categorizing leads by response time ("Under 1 hour," "1-4 hours," "24+ hours") to analyze how speed impacts conversion rates.

Now, let's get into the two primary ways you can create these groups in Power BI.

Method 1: Using the Built-in Grouping Feature (The Easy Way)

Power BI has a fantastic built-in tool that makes creating simple, equal-sized buckets incredibly easy. This is the perfect place to start if you're dealing with numerical data like age, revenue, or quantity, and you don't need complex, custom logic.

Let's use an example of grouping customers by their age from a sales data table.

Step-by-Step Guide to Power BI Grouping

1. Identify Your Field: In the Data pane on the right side of Power BI Desktop, find the numerical field you want to group. In our case, it's Customer Age.
2. Create a New Group: Right-click on the field and select New group from the dropdown menu. This will open the Groups window.
3. Configure Your Bins: In the Groups window, you'll see a few options. Change the Group type dropdown from "List" to Bin.

Now you have two main choices:

• Bin size: This lets you define the exact size of each bucket. For our Customer Age example, if you set the Bin size to 10, Power BI will automatically create groups of 10 years (e.g., 20-30, 30-40, 40-50).
• Number of bins: This lets you define how many total buckets you want. If you set Number of bins to 5, Power BI will look at the minimum and maximum values in your data (e.g., ages 18 to 68) and create five equal-sized groups to cover that range.

For most scenarios, Bin size gives you more predictable and readable groups. Let's set our Bin size to 10.

1. Click OK: Once you click OK, Power BI will create a new field in your Data pane called Customer Age (bins). It's a brand new column in your data model that you can now use in visualizations.
2. Use Your New Grouped Field: Simply drag this new field into a chart or matrix just like any other data field. For example, you can create a bar chart showing Total Revenue by Customer Age (bins).

What was once a confusing scatter plot of individual ages is now a clear bar chart showing which age groups generate the most revenue. Quick, easy, and no code required!

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 Custom Buckets with a DAX Calculated Column (The Flexible Way)

The built-in grouping tool is great, but what if you need more control? What if you want to create buckets with uneven sizes? For instance, with order values, you might want these groups:

• Small ($0 - $50)
• Medium ($51 - $200)
• Large ($201 - $1000)
• Enterprise ($1001+)

You can't do this with the fixed "Bin size" option. This is where DAX (Data Analysis Expressions), Power BI's formula language, gives you the flexibility you need. We'll use a calculated column and a SWITCH function to build our custom logic.

Step-by-Step Guide to Custom Bucketing with DAX

1. Select Your Table: In the Data pane, click on the table containing the data you want to bucket. Let's assume we're working with a Sales table that has an OrderValue column.
2. Create a New Column: Go to the Table tools tab in the ribbon at the top of the screen and click New column.
3. Write Your DAX Formula: The formula bar will appear. Now, we'll write a SWITCH statement. The SWITCH(TRUE(), ...) pattern works perfectly for creating conditional buckets. It checks each condition in order until it finds one that is true, then returns the result.

Here's the formula to create our custom order value buckets:

Order Value Bucket = 
SWITCH(
    TRUE(),
    'Sales'[OrderValue] <= 50, "Small ($0 - $50)",
    'Sales'[OrderValue] <= 200, "Medium ($51 - $200)",
    'Sales'[OrderValue] <= 1000, "Large ($201 - $1000)",
    "Enterprise ($1001+)"
)

Let's break that down:

• Order Value Bucket is the name of our new column.
• SWITCH(TRUE(), ...) tells DAX to evaluate each of the following lines.
• 'Sales'[OrderValue] <= 50, "Small ($0 - $50)": If the value in the OrderValue column is less than or equal to 50, label it "Small".
• This pattern continues for the next conditions. DAX stops checking as soon as it finds a true condition, which is why we don’t have to say 'Sales'[OrderValue] > 50 AND 'Sales'[OrderValue] <= 200.
• "Enterprise ($1001+)" acts as the "else" or default value for anything that doesn’t meet the previous criteria.

1. Press Enter: Once you've written the formula, press Enter. Power BI will instantly create the new Order Value Bucket column and populate it with the correct text values for every row in your table.
2. Sort Your Buckets (Optional but recommended): By default, Power BI will sort text-based buckets alphabetically (e.g., "Enterprise", "Large", "Medium", "Small"). This isn't ideal for a visualization! To fix this, create another calculated column that assigns a numerical order:

Order Bucket Sort = 
SWITCH(
    TRUE(),
    'Sales'[OrderValue] <= 50, 1,
    'Sales'[OrderValue] <= 200, 2,
    'Sales'[OrderValue] <= 1000, 3,
    4
)

Now, select your textual Order Value Bucket column, go to the Column tools tab, click Sort by column, and choose your new Order Bucket Sort column. Your custom buckets will now display in a logical order in all your charts!

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

Which Method Should You Use?

Here’s a quick guide to help you decide:

• Use the built-in Grouping tool when:
• Use a DAX Calculated Column when:

Final Thoughts

Bucketing data is a fundamental skill for transforming raw numbers into organized, easy-to-read reports. Whether you use Power BI's simple built-in grouping feature for a quick analysis or write a custom DAX formula for more control, the result is the same: clearer charts and more obvious insights.

Creating Power BI reports and manually bucketing data saves time compared to using spreadsheets, but the learning curve for DAX can still be steep. At Graphed, we're built to eliminate this complexity entirely. Instead of writing formulas or configuring groupings, you can just ask in plain English: "Show me my total revenue by order size, bucketed into Small, Medium, and Large." We connect to your data sources and use AI to instantly build the tables, charts, and dashboards you need to get answers, turning hours of manual BI work into a 30-second conversation.