Showing results for 
Search instead for 
Did you mean: 
lpowell Visitor

Add custom grouping

I have a need to group department information by commonly referred names non-existent in the data.  To use a grocery analogy, if I had commonly referred names of:

  • Produce
  • Bakery
  • Meat

Departments of: 

Department Number - Department Name

1234 - International Produce

1235 - Local Grown Veggies

1236 - Organic 

1237 - Full of Pesticides

2345 - Fresh Baked

2456 - Day Old

2567 - Baked to Order

3456 - Pre-Packaged

3567 - Cut to Order

3678 - Ready for the Grill


How would I add the commonly referred names then group the department information accordingly.




Larry Powell



Super User
Super User

Re: Add custom grouping

@lpowell Take a look at this DAX pattern. It looks like Static segmentation is what you are after.

Looking for more Power BI tips, tricks & tools? Check out the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
Super User
Super User

Re: Add custom grouping

You could have a look at my Power BI lookup blog article here, this covers the topic pretty well.

I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Moderator v-sihou-msft

Re: Add custom grouping



In this scenario, it's better to add a category id column in both tables, and build the relationship based on this id column. You can hardly populate the commonly referred names based on Department Name matching only.



Helpful resources

New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)