Automate Grouping

[Anonymous]

Hello guys, I'm currently working with a big workbook file which has an attribute field that has to be grouped by product. The only problem is that there is also other information in the field and when I click on new Group I would have to indivially group it all by myself.

Is there anyway to automize that wiht a measure or something? I need the groups for a matrix visualization.

Thanks in advance!

[amitchandak]

@Anonymous ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

You can create a measure or use groups - https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning

[Anonymous]

It looks something like this:

Type        Attribute                                     State

Phone     <Text> iPhone 6s                       active
Phone     iPhone 11 <Text>                       active

Phone     <Text><Text iPhone 6s <Text>  active