Exclude functionality in Word Cloud visualisation does not work when using a slicer

[Anonymous]

I have a question about the word cloud visualisation. I am using the ‘Exlude’ functionality and uploaded a file with stopwords to be removed. This works fine in general, but not when I add a slicer. For example, if I add a gender slicer and I only want to see the words that were entered by females, the stopwords that are supposed to be excluded reappear. Is there any one else who has experienced this problem, and who found a solution for it? Many thanks in advance!

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

"...the stopwords that are supposed to be excluded reappear. "

As tested, the problem you said doesn't appear. In the example, I excluded "January", you can see that "January" will not appear in the above word cloud.

Can you give me a sample data? I should try it by using your data model.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-lionel-msft 

Thank you for your quick reaction! I believe it might have something to do with the relationship that I created between my text file and my stopwords file - I could not find much information about that so I followed an example that I found online but this might not be correct. Therefore I am providing you with a sample of test data in my Power BI project:

https://we.tl/t-r9uhBRD0Fz

The problematic wordclouds are in the last tab 'open vragen optie PBI'. These are based on the data files 'Wordcloudinput' and Stopwoorden'.

Thanks in advance for your help!

Hanne

[projman]

Im having this very same issue.  Did you find a solution?

I have a wordcloud visualisation and i am using a CSV which contains words i dont want to appear in the wordcloud.  I have these set up as a both-way 1:1 cardinality relationship

I then use the CSV in the 'excludes' section for my chart and this works just fine.  Until i either use a page filter or slicer.  Then it seems to completely ignore the CSV.

Would love to know if you solved this issue