Power BI: Creating Custom Data Groups for Better Insights

Grouping data in Power BI allows analysts to simplify such visuals by combining related categories into logical groups or regions. This feature is particularly useful when:

• You want to compare regional trends rather than individual countries.

• Some categories have similar performance and can be viewed as one cluster.

• You want to create custom market groupings without editing the original dataset.

In this exercise, you’ll use Power BI’s visual grouping tool to combine countries from the Revenue_Country table into meaningful groups, such as “High Revenue Markets” or “Emerging Markets.”
This helps you focus your analysis on strategic insights rather than raw data volume

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

Step 1 – Load the Data

1. Open Power BI Desktop.

2. Go to Home → Get Data → Excel.

3. Select the file powerbi_ui_example.xlsx.

4. In the Navigator pane, select the sheet Revenue_Country.

5. Click Load to import it.

Step 2 – Create the Column Chart

1. In the Report view (bar chart icon on the left panel), go to the Visualizations pane.

2. Click the Clustered Column Chart icon.

3. Drag the following fields into the chart well:

   • Axis: Country_Code

   • Values: Revenue

4. The chart will now display Sum of Revenue by Country_Code (as shown in the image).

   Tip: Resize the chart and add a title such as “Sum of Revenue by Country_Code.”

Step 3 – Access the Grouping Option

1. On the chart, right-click on any country’s bar (for example, MY or TH).
   (This opens a context menu.)

2. Select Group data from the list of options.

   • Menu path: Right-click → Group data

   • This action groups the selected data points into a new group category.

Step 4 – Rename and Customize the Group

1. After grouping, Power BI automatically adds a new field called something like “Country_Code (groups)” in the Fields pane.

2. Click the down arrow beside it → select Rename → give it a descriptive name such as “Region_Group”.

3. You can drag other countries into this group manually, or create multiple groups (e.g., High Revenue Markets, Emerging Markets).

Step 5 – Replace Axis with the New Group

1. In the Visualizations pane, remove the original Country_Code from Axis.

2. Drag your new Region_Group field into Axis.

3. The chart now shows Sum of Revenue by Region_Group, summarizing your grouped categories.

Step 6 – Format the Chart (Optional)

• Change the color palette using the Format (paint roller) icon.

• Add Data Labels for readability.

• Adjust chart title to “Sum of Revenue by Country Groups”.

• Sort the chart by descending revenue (ellipsis → Sort by Revenue → Descending).

Step 7 – Save Your Report

1. Click File → Save As.

2. Name it “Grouped_Revenue_By_Country.pbix”.

3. You now have an interactive visual showing grouped countries by total revenue.