cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Word cloud visual how to use the Exclude feature?

Found the Word Cloud visual which was exactly what I need.

 

But I am failing to understand how to use the Exclude field.

 

Anyone knows how it works?

I am guessing it would be a way to add a DataSource with Stop Words?

WordCloud - Exclude Field.png

 

 

30 REPLIES 30
Moderator v-viig
Moderator

Re: Word cloud visual how to use the Exclude feature?

Hello @jagostinhoCT

 

You are correct. The data-set should containt a column with stop words in order to use Exlude feature of Word Cloud.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Word cloud visual how to use the Exclude feature?

I am trying to use another Datasource (XLS file w/ column of Stop words) but it then breaks the visual.

Moderator v-viig
Moderator

Re: Word cloud visual how to use the Exclude feature?

Are you trying to use another data table? What error do you get?

Pleaes note that stop words must in the same table along with data. As an another option, you can specify the relationship for two tables.

 

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Word cloud visual how to use the Exclude feature?

I am using a different table. In fact, using a different XLS file just with a column called "StopWords". This way I thought that I could use the same datasource in multiple PBIX where I have the WordCloud visual. In case I wanted to add a Stop Word I would just edit it so that it would update in all reports.

 

But from you are saying, my understanding is that I will need to have a Key Column so to establish a relationship with other tables? My other tables content can vary a little. Any suggestions on how I might be doing that successfully?

 

Thank you

Moderator v-viig
Moderator

Re: Word cloud visual how to use the Exclude feature?

Yes, your understanding is correct. You have to include a special Key Column to make the relatiionship.

Another option is to use "Words" field to fill stop words (you can find this option at Format Panel -> Stop Words).

Please note that you should use the space as a separator for words.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Word cloud visual how to use the Exclude feature?

Thank you @v-viig.

 

Even though I got the concept correct, I am still unclear on how to setup the Key Column.

Let's say that I use something like the JobIDCode which I already have in my other datasources.

I ad a JobIDCode to my StopWords file but how would it look like?

Always the same JobIDCode in each row?

Single row with one JobIDCode (which one?) and a cell w/ all the StopWords?

 

There is no example for this in the sample file. Would it be possible to send me an example PBIX?

Moderator v-viig
Moderator

Re: Word cloud visual how to use the Exclude feature?

Please take a look at this sample report that represents the usage of Excludes data-field.

 

Please let me know if you have any further questions.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

anaorca1990 Regular Visitor
Regular Visitor

Re: Word cloud visual how to use the Exclude feature?

Hello

 

i saw your answer and im trying to do the same, is there any way i can see the queries that form that visualization in power bi

GBI_Stockholm Occasional Visitor
Occasional Visitor

Re: Word cloud visual how to use the Exclude feature?

Hi

 

I'm trying do do the same thing as you, I want to clean my wordcloud providing several stopwords. I do not want to use the copy paste function but rather the exclude function.

 

 

As for now power bi does not recognize the relationship and I can't make it work. The lenght of the sopword column are not the same as the column that contains the text.

 

Do you have any example file or suggestions on how to do make the stopwords work in worudcloud/power bi?

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 293 members 2,883 guests
Please welcome our newest community members: