Column Aggrupation

Hi ljimenezvega84,

Yes, it's absolutely possible to group values in Column A (e.g., by product type like TV, Laptop, etc.) into custom-defined groups of 20–30 products each in Power BI (or even in Excel or other tools). Here's how you can approach it:

Option 1: Manual Grouping in Power BI
Go to the Data view.

Click on Column A (Product).

From the top ribbon, choose "New Group".

In the Grouping dialog:

Use "List of values" or manually select product names.

Create your 10 groups by assigning products accordingly (e.g., Group 1 = TV, Laptop; Group 2 = Dishwasher, Chair, etc.).

Name each group clearly.

This creates a new column with your groupings.

 

Option 2: Custom Group Table (Preferred for Large Datasets)
Since you have 200–300 products, manual grouping might get tedious. Instead, use a mapping table like this:

Product Product Group

TV	Group1
Laptop	Group1
Dishwasher	Group2
Chair	Group3

Steps:

Create this table in Excel or Power BI.

Import it into your model.

Create a relationship between your main table’s Column A and the mapping table's Product.

Use the Product Group field in your visuals or aggregations.

 

Or,

 

To avoid hardcoding, you can use Power Query (M) to create a rule-based column, or even a DAX calculated column like:

ProductGroup =
SWITCH(TRUE(),
'Table'[Column A] IN {"TV", "LAPTOP"}, "Group 1",
'Table'[Column A] IN {"DISHWASHER", "OVEN"}, "Group 2",
'Table'[Column A] IN {"CHAIR", "TABLE"}, "Group 3",
"Other"
)

 

 

Please mark this post as solution if it helps you. Appreciate Kudos.