Power BI: Creating Bins for Numeric Fields

In datasets with continuous numeric or sequential values—such as Customer IDs, ages, or sales amounts—it can be difficult to interpret individual values on a chart.
Binning (or grouping numeric data into intervals) helps summarize and visualize trends across ranges instead of single points.

In this exercise, you’ll create a Customer_ID bin to group customers into 5 equal ranges, allowing you to view total Quantity per customer group rather than for each individual customer. This is useful for identifying broader patterns, such as which customer segments purchase more frequently.

Download https://archive.org/download/powerbi_dataset/powerbi_ui_example.xlsx

Step 1 – Load the Dataset

1. Open Power BI Desktop.

2. Select Home → Get Data → Excel.

3. Choose the file powerbi_ui_example.xlsx.

4. In the Navigator window, select the Sales table.

5. Click Load to import the data.

Step 2 – Create the Initial Chart

1. In Report view, click on the Clustered Column Chart icon from the Visualizations pane.

2. In the Fields pane, drag the following:

   • Axis: Customer_ID

   • Values: Quantity

3. The chart now displays Quantity by Customer_ID, showing each customer as an individual bar (as in the first image).

Step 3 – Open the Grouping (Binning) Dialog

1. In the Visualizations pane, locate the Axis field well.

2. Click the down arrow beside Customer_ID (label 1 in image).

3. Choose New group from the dropdown (label 2).

Step 4 – Configure the Bin Settings

The Groups dialog box will open (as shown in the second image).
Configure it as follows:

Click OK when done.
A new field named Customer_ID (bins) will appear under the Sales table in the Fields pane.

Step 5 – Replace the Axis Field

1. In the Fields pane, check Customer_ID (bins) to add it to the chart.

2. Remove the original Customer_ID from the Axis section of the Visualizations pane.

3. The chart now displays Quantity by Customer_ID (bins) — i.e., total quantity per group of customers (see the third image).

   • Each bar represents a bin range (for example, 100–120, 121–140, etc.).

Step 6 – Format the Chart

1. Select the chart → click the Format (paint roller) icon.

2. Update the following:

   • Title: “Quantity by Customer_ID (bins)”

   • Data Colors: Choose a clear shade of blue for consistency.

   • Data Labels: Turn On for better readability.

3. Resize the chart and adjust axes labels as needed.

Step 7 – Save Your Report

1. Go to File → Save As.

2. Name it “Customer_Bins_Analysis.pbix”.