Word Cloud - Stop words

Hi, mpfraser7,

you can make use of Power Query(Edit queries) in Power BI.

First split your column 1 by space, make sure you expand the Advanced Options,  and check the "Select into Rows". Then do the same for ".", "," and "?". 

Filter out all blank rows from your column. Each row will now be on a separate word.

Now create a table with your stop words, e.g. create it in excel and import it, or by the "Enter data" functionality in Power BI/Power Query.

Now make use of the Merge Queries-function in the Home-ribbon, and merge the to tables. The rows where there is a match between the two table will have a value, the others will be null. To make it easier to filter, add a new custom column like this:

=if [Stop words.words] is null then 1 else 0

and filter the table on this column = 1. After this filtering you can remove the merge column and the added column. Then only words which are not stop words will be loaded to your model.

mockup-report

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

Mockup