Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
arun2001mjl
Helper II
Helper II

Word Cloud Issue

Hello All,

I have a description column with 200 Rows. I want to filter the unique keywords from Description column using Word cloud in powerbi. 

Example: It was showing like...

Server - 20

Down - 18

Access - 30

Hung - 21

It works fine when Word-Breaking is ON...

 

When i OFF the work breaking, the Word cloud becomes blank.. Actually it should show 2 or 3 words

Server down - 12

Server Access - 11

Server Hung - 10

 

but it is not showing anything and it is blank. How to fix this?

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

My approach would be to first create a single column table with all keywords that you want to search for in the Description column.  Then we will write a calculated column formula to extract those keywords from the Description column.  The Word cloud would be created from this new calculated column.  Could you have multiple keywrods that you want to extract from the Descrioption column?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Hi,

My approach would be to first create a single column table with all keywords that you want to search for in the Description column.  Then we will write a calculated column formula to extract those keywords from the Description column.  The Word cloud would be created from this new calculated column.  Could you have multiple keywrods that you want to extract from the Descrioption column?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Ashish_Mathur
Super User
Super User

Hi,

My approach would be to first create a single column table with all keywords that you want to search for in the Description column.  Then we will write a calculated column formula to extract those keywords from the Description column.  The Word cloud would be created from this new calculated column.  Could you have multiple keywrods that you want to extract from the Descrioption column?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
lbendlin
Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.