Word Cloud

[backuserichsen]

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 the words i can't seem to make it hapen. The issue is the words with small letters where there is no , or .. How do i split the words?

[AllisonKennedy]

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

[backuserichsen]

@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. 

[AllisonKennedy]

@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]

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.

[v-rzhou-msft]

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.