WordCloud

[KBD]

Hello:

I am trying to create a simple work cloud.

Can not get the effect I need.

My data is as follows:

Indicents contains details on incidents.  Date, time,  location,  description  

These are Slips , falls,  spills  etcs   Call this table Incidents.

Keys words this contains key words that management wants to track.

Slip, fall, oil,  Antifreeze, Extinguisher   etc..

There is no link between these tables.

I need a WordCloud that scans the Incident description for only the words in Key Words.

How do I do this?  I see postings that state I need to create a link betwwen Incidents and Key Words, 

But that make no sence.

Any assistance is appreciated.

KD

[KBD]

Rita:

Thank, many thanks you lead me to a workable solution.

In a new table, I extracted the key words from the descriptive text to a new attribute, with corresponding counts.

Then put the word cloud on top of this new table.

Just a bit of Python code to get word list and count.

Thanks again.  KD

[Ritaf1983 · Accepted solution]

HI @KBD 

What you observed is correct. Since we don't have filtering options based on "contains" or list searches, in order to focus the Word Cloud on specific keywords, there must be a relationship between the tables.

To achieve this, you need to split the description into rows, so that each word appears in its own row.

You can make needed transformations from data source directly or with a power query.
From power query, you can follow these steps :

1. Duplicate the column of description :

2. Split the Description column into rows:

After closing and applying you can create a relationship between keywords and incidents 

Now you can create the cloud :

The pbix is attached

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

[KBD]

Ritaf:

do not understand why I cannot click on your posting as the accepted answer.

You should get the credit.

KD