Forum Discussion
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
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?
So if you go back to Lazer's question. How are the keys 1 and 2 related to each other?
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.
Yes, I understand that. Thanks.
Can you give more insight into this question from above? "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."
Thanks,
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
Both table must have a Key (call it as you want) column that containse excluding words.
Rows will be contcatenated by key value.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
It does not matter how mmany words are in the tables. Tables must have key column with numeric indexes.
Tables should also have a relationship in Power BI that is built on the key column. This is a small hack to use both tables in a single visual.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Hi jason435
Could you solve your problem in the meantime?I have absolutly the same problem here and would be very grateful 🙂
Cheers
qwertzuiop
