Forum Discussion

Frequent Visitor

4 years ago

Word Cloud

Hey, I am trying to creat a word cloud of Warrentt Buffet letter from 2021 (https://www.berkshirehathaway.com/letters/2021ltr.pdf) When i import the letter in to Power Bi desktop and try to split t...

Community Champion

4 years ago

backuserichsen I'm not sure what you mean by split the words. Can you share your results so far and highlight the problem areas?

Frequent Visitor

4 years ago

AllisonKennedy as you can see inn the wordcloud i get the ful colum when i applay the wordcloud. I can't seem to find out how to split the words in the column as they have more then one delimiter. And i am also not sure how to split words that has noe delimiter between them.

Anonymous
Not applicable
4 years ago
Hi backuserichsen ,

As far as I know, you can split column by delimiter.

For reference:

Split columns by delimiter

For the value which has noe delimiter between strings, I think you couldn't split them automaticlly.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AllisonKennedy
Community Champion
4 years ago
backuserichsen You can't split that data as there is no pattern or delimiter for it. What is the raw data source? Why have the spaces between words been removed?
- backuserichsen
  Frequent Visitor
  4 years ago
  Hey AllisonKennedy
  The data source is the Warrant Buffet letters to the stakeholders of Berkshire Hathaway Inc. This is a school task and the task question is a follow
  
  Task 2.1 (20 Points) Word Cloud
  
  Investor Warrant Buffet has a habit of writing letters to the stakeholders of Berkshire Hathaway Inc,
  most of which are available online at https://www.berkshirehathaway.com/letters/letters.html.
  Make a word cloud of Buffet’s letter from 2021, using Power BI.