topic Re: Word cloud visual how to use the Exclude feature? in Custom Visuals Development Discussion

Word cloud visual how to use the Exclude feature?

Anonymous — Thu, 07 Dec 2017 11:37:20 GMT

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?

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

v-viig — Fri, 08 Dec 2017 09:34:54 GMT

Hello @Anonymous

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?

Anonymous — Wed, 13 Dec 2017 16:50:46 GMT

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

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

v-viig — Thu, 14 Dec 2017 07:50:18 GMT

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?

Anonymous — Thu, 14 Dec 2017 09:41:58 GMT

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

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

v-viig — Fri, 15 Dec 2017 07:19:19 GMT

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?

Anonymous — Fri, 15 Dec 2017 09:38:42 GMT

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?

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

v-viig — Mon, 18 Dec 2017 11:05:47 GMT

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

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

anaorca1990 — Tue, 28 Aug 2018 21:35:57 GMT

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

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

GBI_Stockholm — Mon, 17 Sep 2018 08:17:25 GMT

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?

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

v-viig — Mon, 17 Sep 2018 12:56:10 GMT

Do you use different tables? If so, please learn how to make a relationship between two table otherwise PBI won't be able to use these tables together.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

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

jsdanie1 — Wed, 26 Sep 2018 23:43:36 GMT

Has anybody actually gotten this to work? I'm having the same issue with exclude feature. The exclude feature isnt really working as it really should be. I created a Excluded Words Table list, not able to map it as (1:1). Keep getting "The cardinality you selected isn't valid for this relationship.

Trying to map it to a comments text field. Don't really want to have to type out 100+ Stop Words.

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

jsdanie1 — Wed, 26 Sep 2018 23:46:09 GMT

Trying to map it to a comments text field. Don't really want to have to type out 100+ Stop Words.

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

v-viig — Thu, 27 Sep 2018 07:05:36 GMT

Two tables must have relatioship by common column. You might add ID column to match tables.

Otherwise, Power BI will reject such tables.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

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

jsdanie1 — Thu, 27 Sep 2018 16:00:57 GMT

That seemed to help better and actually get some of it working now. Thank You. Do you know why it would still be showing words even though I've exclude it. I'm noticing some words get excluded, and some arn't. It appears to be comments where the word is used multiple times in the sentenced that arn't being excluded.

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

v-viig — Fri, 28 Sep 2018 07:19:15 GMT

Can you share a Power BI Report to reproduce the issue?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

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

AssisJadue — Fri, 28 Sep 2018 13:28:09 GMT

I am having exactly the same issue. I'm using a Direct Query with one fact table and aonther XLS file with the stop words. I create an index and a relationship between both tables but still not excluding the words in my visual.

Could you please help me out to understand this issue?

Assis Jadue

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

jsdanie1 — Fri, 28 Sep 2018 15:46:40 GMT

Attach is the link to the file.

https://1drv.ms/u/s!Ak-gR66cp9H5gYsqMed68G1s1_vzQQ

Should be publically viewable. Let me know what you think. Thanks for all the help. Overview of what i'm trying to do. We are basically using the Word tag to grab comments customers make from a survey. We would like to see trending words of adjectives or branding related words customers are saying about our company and elminate some of the unimportant words in the dictionary.

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

v-viig — Mon, 01 Oct 2018 07:27:20 GMT

Have you tried to remove a column from Values data field and turn on Show Items with no data for other columns (Category and Excludes) ?

Let me know if it fixes the issue.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

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

AssisJadue — Mon, 01 Oct 2018 12:57:49 GMT

Thanks for your answer. I've tried what you suggested but still can't get it right . I removed the column from values and turn on the "Show Items with no data" for the other columns. I still have the words that suppose to be excluded.

Anything else that I am doing wrong?