Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Create a Range in Power BI

Cody Schneider••7 min read

Transforming rows of raw data into a clean, insightful report often requires simplifying your visuals. Grouping numerical data into logical ranges - like age brackets or pricing tiers - is one of the most effective ways to do this in Power BI. This article will guide you through the process, covering the easiest built-in methods and the more flexible DAX formulas for creating custom ranges.

GraphedGraphed

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.

Watch Graphed demo video

Why Group Data into Ranges?

Imagine you're analyzing sales data for a company with customers ranging from 18 to 80 years old. A bar chart showing sales for every single age would be crowded and difficult to read. It's hard to spot a trend in 62 different bars. By grouping those ages into buckets like "18-25," "26-35," "36-45," and so on, you can see at a glance which age demographic contributes the most to sales.

Grouping is all about summarizing data to make it more digestible. It helps you:

  • Reduce Noise: Condense dozens or even hundreds of individual data points into a handful of clear categories.
  • Improve Readability: Make charts and tables easier for your audience to understand quickly.
  • Identify Trends: Uncover patterns within cohorts that would be invisible at a granular level. For example, are products in the "$50-$100" price range more popular than those in the "$101-$150" range?

Fortunately, Power BI provides several ways to accomplish this, from a simple point-and-click interface to powerful custom formulas.

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.

Method 1: Using the "Groups" Feature for Numerical Data

The simplest and quickest way to create ranges for numerical data is by using Power BI's built-in grouping feature, often called "binning." This is perfect for when you need evenly sized groups, like grouping by every 10 years or every $50.

Let's walk through an example. Say we have a "Sales" dataset and we want to group sales transactions by the customer's age.

Step-by-Step Guide to Binning

  1. Find Your Field: In the Fields pane on the right side of the Power BI window, find the numerical column you want to group. In our case, it’s the Customer Age field.
  2. Create a New Group: Right-click on the Customer Age field. From the context menu that appears, select New group.
  3. Configure Your Bins: A "Groups" window will pop up. This is where you define how your ranges will work.
  4. Set the Bin Size: For our example, let's select Size of bins and set the Bin size to 10. Power BI will automatically detect the minimum and maximum ages in your data and create the bins accordingly.
  5. Finalize the Group: Click OK. Power BI will create a new field in your Fields pane. It will usually be named Customer Age (bins). You can rename this to something more descriptive like Age Group by right-clicking it and selecting "Rename."

Using Your New Group in a Visual

Now that you've created your Age Group field, you can use it just like any other column. Drag the Age Group field onto a chart's Axis and drag a measure like Sales Amount into the Values area. Instantly, you'll have a clean, easy-to-read chart showing sales performance across different age brackets.

GraphedGraphed

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.

Watch Graphed demo video

Method 2: Creating Custom Ranges with DAX Formulas

The binning feature is great for uniform ranges, but what if you need ranges with different sizes? For example, you might want price brackets like "$0-$20" for low-cost items, "$21-$100" for mid-range items, and "$101+" for premium items. This is where DAX (Data Analysis Expressions) comes in.

Using a DAX calculated column gives you complete control to define any custom logic you need. The best function for this task is SWITCH(), which is a cleaner and more efficient alternative to long, nested IF() statements.

Step-by-Step Guide Using DAX and SWITCH()

  1. Switch to the Data View: In the left-hand navigation pane of Power BI, click on the "Data" icon (it looks like a table).
  2. Create a New Column: Select the table containing the data you want to group (e.g., a "Products" table with a Price column). In the ribbon at the top, under "Table Tools," click New column.
  3. Write the DAX Formula: The formula bar will appear. Here, you'll define your new ranges using the SWITCH() function. The structure looks like this: SWITCH(TRUE(), condition1, result1, condition2, result2, ..., else_result). It works by evaluating each condition until it finds the first one that is TRUE() and then returns the corresponding result.
  4. Confirm the Formula: Press Enter to create the calculated column. Power BI will go through every row in your "Products" table, check the Price, and assign the correct "Price Bracket."

How the DAX Formula Works

It's crucial to understand the order of operations here. The SWITCH(TRUE(), ...) statement checks each line sequentially.

  • For a product priced at $15, the first condition ('Products'[Price] <= 20) is true, so it assigns "0-20" and stops.
  • For a product priced at $75, the first condition is false. It moves to the second condition ('Products'[Price] <= 100), which is true. It assigns "21-100" and stops.
  • Anything over $100 will fail both conditions, so it falls into the final "else" result, which is "101+".

Because of this, the order of your conditions matters immensely. Always list your conditions from smallest to largest or largest to smallest to ensure your logic works correctly.

Bonus Method: Grouping Categorical (Text) Data

Creating ranges isn't just for numbers. You often need to group related text categories. For instance, you might want to group several US states into a larger "Sales_Region" like "West Coast" or "Northeast." The process is very similar to numeric binning but uses the "List" group type.

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.

Steps for Grouping Text Categories:

  1. Select the Text Field: In the Fields pane, right-click the text-based column you want to group, such as State, and select New group.
  2. Group the Values: The "Groups" window will open with the "Group type" set to List. In the "Ungrouped values" list, you can select multiple items you want to put into a single group. Hold down the Ctrl key to select multiple states (e.g., "California," "Oregon," "Washington").
  3. Click "Group": With your states selected, click the Group button. This will create a new entry in the list on the right, which contains the states you selected.
  4. Rename the Group: Double-click the newly created group name to rename it to something meaningful, like "West Coast."
  5. Include an 'Other' Group (Optional): At the bottom, there's a checkbox for Include "Other" group. If you check this, any values you didn't manually place into a group will be lumped together into a single category named "Other." This is handy for cleaning up miscellaneous values.
  6. Click OK: A new field (State (group)) will be added to your Fields pane, ready to be used in your reports to show data by custom region.

Tips for Effective Grouping

Whichever method you choose, keep these best practices in mind to get the most value from your ranges.

  • Use Clear Names: Rename your grouped fields and the groups themselves to be descriptive and intuitive. Age Group is much clearer than Customer Age (bins).
  • Consider Your Audience: Create ranges that make sense contextually. For a financial report, ranges based on thousands (0-10k, 10k-50k) are more useful than arbitrary numbers.
  • Keep It Simple: The entire point of grouping is simplification. If you end up with 20 different ranges, you’ve likely over-complicated things and defeated the purpose. Aim for a handful of meaningful groups.
  • Verify Your Logic: Especially when using DAX, always double-check your work. Create a simple table visual with your original column and your new grouped column to spot-check if values are being categorized as you intended.

Final Thoughts

Knowing how to effectively group data into ranges is a fundamental skill that elevates your Power BI reports from messy tables of data to clean, compelling visual stories. By mastering both the easy-to-use grouping feature for simple cases and flexible DAX formulas for custom scenarios, you can transform your raw data into actionable insights much more efficiently.

While building these skills in Power BI is rewarding, we know that getting insights shouldn't always involve writing formulas or navigating multiple menus. We created Graphed to remove this technical barrier entirely. You can connect your data sources in seconds and simply ask a question like, "show me total sales by country and device type," and get an interactive dashboard instantly. It automates the report-building grind so you can spend less time wrangling data and more time making decisions.

Related Articles