Forum Discussion
the_kent
5 years agoNew Member
Need help figuring out a tricky WordCloud visualisation!
What I'm trying to achieve: Use the WordCloud graph add-on to visualise the relative occurance of keywords and highlight them BASED on the entity who has the largest occurance of said keyword.
Data sample:
| Company | Key words |
| Company A | Apple, Orange, Banana |
| Company B | Apple, Banana, Orange |
| Company C | Orange, Apple |
| Company A | Orange |
| Company B | Apple |
Giving context to the data above:
- Company A is associated with Apple, Orange and Banana in Line 1- however, across the rest of the data you'll see that Company A has been associated with Orange again. So, a total of 2 times
- While at the same time Company B & C has been associated with Orange as well, but only once each
- Same case with Company B and Orange
- Banana has an been mentioned lesser AND there's no difference between how many times it's been mentioned by either company A/B
The output I want in the WordCloud:
- A wordcloud where Orange & Apple are at the same size given that they are the most repeated term in the dataset - BUT it takes a data colour associated with Company A and Company B respectively as they are most associated with those terms (something like below)
Is this possible with either Microsoft's WordCloud viz add-in (preferably) or anyone else's?
Understand this is a bit complex and possibly niche, but happy to change tracks to another visualisation which fits into 'What I'm trying to achieve' above!
1 Reply
- MFelixSuper User
Hi the_kent ,
Have you tried the TagCloud by X-Viz?
It allows a series of custom formatting:
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200000542?tab=overview