Skip to main content

Power BI

New

Improve the WordCloud visual

Vote (16) Share
John Philpott's profile image

John Philpott on 14 Jun 2016 00:02:39

Was happy to find a WordCloud visual by Microsoft in the gallery. Then I tried using it. The tool needs some more customizations, most importantly some smarts to ignore common words such as 'the', 'and', 'it', etc. Secondary to this, the ability to customize minimum number before a word appears would be helpful as well.

Comments (3)
John Philpott's profile image Profile Picture

e278e71c fa8e-4045-83e6-45d19cd11dd6 on 06 Jul 2020 00:10:11

RE: Improve the WordCloud visual

Need bi-gram feature

John Philpott's profile image Profile Picture

22f69d3e 8b94-4c26-a39a-87aebdf3da05 on 05 Jul 2020 23:59:19

RE: Improve the WordCloud visual

The stop words work well but apostrophes do not get filtered either...

I also agree with Joie's comments.

John Philpott's profile image Profile Picture

9548edec 4af8-466e-8678-cf71117f0e28 on 05 Jul 2020 22:30:44

RE: Improve the WordCloud visual

I found that enabling the default stopwords in the visual did the trick for most common English words to filter out. I do agree though that it is missing many customizations. Advanced stopwords, alternate stopword lists, string length on stopwords, color customization - these are all lacking in the current visualization.

Currently I am playing with the tm and wordcloud packages in R to get what I need for wordclouds. They provide for all the above that I mentioned plus you can filter out numbers, punctuation, sort out case inconsistencies and plot to an image if needed (although I have not played with that yet).