Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
@backuserichsen I'm not sure what you mean by split the words. Can you share your results so far and highlight the problem areas?
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@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.
@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?
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
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.
Hi @backuserichsen ,
As far as I know, you can split column by delimiter.
For reference:
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |