Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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 Da...
v-viig's avatar
v-viig
Community Champion
7 years ago

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

[email protected]

jason435's avatar
jason435
Helper II
7 years ago

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,

  • v-viig's avatar
    v-viig
    Community Champion
    7 years ago

    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

    [email protected]