different words for one generic keyowrd

[Anonymous]

Hi 

I need some help to create a word cloud.

My problem is that I want to create a keyword list. The individual keywords should be a generic term for different words.

For example the keyword is display.

In another list I want to set the words monitor, screen, display, panel... to the keyword display. 

Do you have any idea how to code this.

Thanks

[v-juanli-msft]

Hi @Anonymous 

Do you want to create a keyword list based on exsiting data?

If so, could you show an example of the data and clear me the rule to exact the key words from it?

As searched, you could follow this guide to create a word cloud in Power BI.

https://www.youtube.com/watch?v=AblTenl9fqo

https://www.sqlshack.com/how-to-create-a-word-cloud-generator-in-power-bi-desktop/

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Yes you are right! @v-juanli-msft 

I want to create an own list. In this list I want to have keywords and the different keywords should be a definition for some other terms.

After that I want to use this keyword list to count how often it shows up in the incoming tickets...

Normally if I search for the keyword "display" it only shows how often "display" appears in the tickets. But I want that it counts whenever the cognate term for example "monitor" or "screen" appears.

I hope you understand what I need.

[v-juanli-msft]

Hi @Anonymous 

Do you have all words in on one column

list

monitor

screen

display

panel

fruit

banana

apple

apple

panel

screen

screen

apple

cloths

t-shirt

t-shirt

t-shirt

skirt

trouser

Or have data as below

name	explain
monitor	it is display
screen	a kind of display
panel	best sale display
banana	good fruit
apple	fruit you like
apple	fruit
panel	it is display
screen	a kind of display
screen	best display
apple	fruit
t-shirt	cloths
t-shirt	cloths
t-shirt	cloths
skirt	cloths
trouser	cloths

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi

In each row there is a text and the words should be searched in every row.

The data looks like that: