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.
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.
Ritaf:
do not understand why I cannot click on your posting as the accepted answer.
You should get the credit.
KD
