cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
qwertzuiop
Advocate II
Advocate II

Create word cloud and use stop words through the "exclude" field

Hello dear Community

 

If I have a table with 1000 long form answers (sentences), and I create a table with stopwords. How do I setup key columns to link the two tables? The table inherently don't have any relationship to each other."

 

Cheers

qwertzuiop

1 ACCEPTED SOLUTION
mahoneypat
Super User
Super User

I tried to do this with Word Cloud and was surprised it didn't accept columns from unrelated tables.  Two ways around this.

 

1. Make a relationship between your column containing the long text and the one with your stopwords.  Doesn't matter what kind of relationship, or if there are no matches.

 

2. Make a new blank query where you force those two columns in the same table with something like this.

= Table.FromColumns({StopWords[StopWords], TextTable[TextColumn]})

Then use the columns from this new table in your visual. 

 

#1 is easier, but I came up with #2 first so sharing both.

 

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

2 REPLIES 2
mahoneypat
Super User
Super User

I tried to do this with Word Cloud and was surprised it didn't accept columns from unrelated tables.  Two ways around this.

 

1. Make a relationship between your column containing the long text and the one with your stopwords.  Doesn't matter what kind of relationship, or if there are no matches.

 

2. Make a new blank query where you force those two columns in the same table with something like this.

= Table.FromColumns({StopWords[StopWords], TextTable[TextColumn]})

Then use the columns from this new table in your visual. 

 

#1 is easier, but I came up with #2 first so sharing both.

 

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


amitchandak
Super User
Super User

@qwertzuiop , Can you share sample data and sample output in a table format?

 

You can have measure  like

calculate([measure], filter(Table,not( Table[word] in values(table2[stop word]))))

or

calculate([measure], filter(Table,not( Table[word] in allselected(table2[stop word]))))

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors