Forum Discussion
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
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?
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
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
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?
Thanks for the example. But could you elaborate on the role of the key column between the two tables?
For example, the Words dataset includes the words "Power BI" and "Microsoft" with keys 1 and 2 respectively. The Excludes dataset includes the words "Javascript" and "LESS" with keys 1 and 2. I would expect that the exclusion word "Javascript" is applied to "Power BI" and "LESS" is applied to "Microsoft". In that case, the exclusion list should have no effect on the word cloud. However, every word in the exclusion list seems to be applied to every word in the target dataset.
It is really hard to grasp the meaning of the key column. Although it is required, it seems that it has no effect on how the word cloud is presented? Why is it required?
Key column is required to make a relation for two or more tables. This requirement comes from from how SQL handles tables.
In other words, table must have primary kyes that might be use to join tables.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
v-viig, that did the trick for me also, but it's not obvious and there are no clear instructions when downloading the visual. I have just left a review on AppSource saying how clunky it is and whilst your answer may add a star to my rating I still hold that it's not intuitive - it would be much better just to add a list of words stright to the Excludes field without extra index fields and a relationship being needed.
