Forum Discussion
Word cloud visual how to use the Exclude feature?
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
Thank you v-viig.
Even though I got the concept correct, I am still unclear on how to setup the Key Column.
Let's say that I use something like the JobIDCode which I already have in my other datasources.
I ad a JobIDCode to my StopWords file but how would it look like?
Always the same JobIDCode in each row?
Single row with one JobIDCode (which one?) and a cell w/ all the StopWords?
There is no example for this in the sample file. Would it be possible to send me an example PBIX?