How to find any word similar in the column make group(Cluster) in power bi

[arvindyadav]

Hi Team,

I need a group of data having one of the words the same in the column and make those keywords to the group(Cluster) in Power BI Desktop.

Please find the format below

Cluster(Group)	Keywords
Credit(Group1)	Credit Cards Anyone Buy
Credit score
Buy Credit Cards
Credit the money
Apple(Group2)	Apple Phone
Apple Ipad
Apple Pro

So on.....

This is what I want where I have keywords column but I need Cluster(Group) column.

Thanks,

Arvind

[arvindyadav]

Hi @v-yuta-msft,

I have 12000 keywords so it is difficult to groping manually. I need the function like the word or text or phrase cluster and make a group of similar word or text clustering. ie, If any keyword has the same word then make those keywords into one group same as for the 2nd group and so on. We can consider the same word name as a group name.

Thanks,

Arvind

[arvindyadav]

Hi @v-yuta-msft ,

Any update on it?

Thanks,

Arvind

[arvindyadav]

Hi @v-yuta-msft ,

There?

[arvindyadav]

Hi @v-yuta-msft ,

Any update on this?

Thanks,

Arvind

[v-yuta-msft]

@arvindyadav ，

To be general, you may use "Group" feature in power bi which can meet your requirement.

https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.