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...
jsdanie1's avatar
jsdanie1
Frequent Visitor
7 years ago

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. 

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

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

[email protected]

  • jsdanie1's avatar
    jsdanie1
    Frequent Visitor
    7 years ago

    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. 

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

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

       

      Ignat Vilesov,

      Software Engineer

       

      Microsoft Power BI Custom Visuals

      [email protected]

      • AssisJadue's avatar
        AssisJadue
        Frequent Visitor
        7 years ago

        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