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 DataSource with Stop Words?

 

 

32 Replies

  • 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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi, I had the exact same problem with 1500+ Articles and 600 Stop Words. It turned out, that my Article-column had duplicate entries that woulnd't allow for a join. Maybe this helps in your case too.

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

    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

    [email protected]

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

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

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

        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

        [email protected]

  • 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.