Alternative Solution to Substitute Word for Word Cloud

[J_Mug]

Hi,

I like to use the word cloud visual, but this time there are too many filler words, so much that they can't be removed with format options of the visual.

I use this formula with substitute to change words not wanted with blanks, but it's slow and I wonder if there might be something better performance-wise. Can someone recommend an alternate function/way or is this the only way?

Basically, I create a calculated column and use this function with as many substitutes as words:

Filtered comments =

Substitute(

Substitute(

Substitute(

'Table' [Coments Column],

"Word not wanted",""),

"Word not wanted",""),

"Word not wanted","")

Kind regards,

[V-pazhen-msft · Accepted solution]

@J_Mug 

Select the comment column, and right click choose Replace Value, then replace unwanted words to nothing. You may have many words but this method should be faster than Substitute() in dax.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@J_Mug , Why do you want to replace word, you do not wanted.

Remove them using filter or slicer

[J_Mug]

Because I want to use the Word Cloud visual which displays all words in a column that contains the open comments from people (So unrelated words that don't provide information need to be removed. Ej: the, most [¿The most what would be the question people would make if you display that], better, good, ok, etc).

The problem is it has limited word removal and so for thousands of inputs it needs more pruning, that's why I use that formula and why am asking if there is some other alternative.

Filter or slicer would remove the whole comment, which contains words I want in the word cloud.