Forum Discussion
Word cloud visual how to use the Exclude feature?
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
I am trying to use another Datasource (XLS file w/ column of Stop words) but it then breaks the visual.
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
I am using a different table. In fact, using a different XLS file just with a column called "StopWords". This way I thought that I could use the same datasource in multiple PBIX where I have the WordCloud visual. In case I wanted to add a Stop Word I would just edit it so that it would update in all reports.
But from you are saying, my understanding is that I will need to have a Key Column so to establish a relationship with other tables? My other tables content can vary a little. Any suggestions on how I might be doing that successfully?
Thank you
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