Forum Discussion
Word cloud visual how to use the Exclude feature?
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?
Please take a look at this sample report that represents the usage of Excludes data-field.
Please let me know if you have any further questions.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Hello
i saw your answer and im trying to do the same, is there any way i can see the queries that form that visualization in power bi
