Forum Discussion
WordCloud
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.
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