cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
AF_Archives
Frequent Visitor

Power BI WordCloud content in table?

In Power BI, once a word Cloud has been created, is there a way to view that same word cloud as either a bar chart or table to see a list of the words and associated quantities that are used to create the word cloud?

6 REPLIES 6
brownrice
Helper III
Helper III

Just to revive this as it sounds similar/the same as a question I have, if i have the below word cloud, is there a way to convert the below info into a table to show a count of each word. for example:

shall 100

know 75

lord 50

...

brownrice_0-1664003224290.png



AF_Archives
Frequent Visitor

Hi,

We have a rather large spreadsheet (15K rows) with a column "Reason for Retention" containing free form text.

We wanted to see if there were common expressions or reasons for different categories of the data. 

While the wordcloud gives the "first" word only and we have tried to remove many "noise" words, we still can't find any meaningful insight of "Reasons for Retention" and it is hartd to distinguish size of words for frequency.

We thought if we could see a bar chart, we could scroll down.

We have used "Show as a table" from the ... ellipses on the word cloud - but again this did not help.

 

We may be going about this incorrectly, so absolutely open to suggestions 🤓

 

 

 

@AF_Archives 

 

I'm sorry, it's hard for me to imagine your problem out of thin air if you didn't provide any sample...

AF_Archives
Frequent Visitor

Thankyou for replying @amitchandak .

I am very new to Power BI - could you please explain the steps involved of how I can get the keywords that are extracted from the word cloud and list them in a table  or bar chart so that I can see all of the keywords extracted and their corresponding frequency.

Hi, @AF_Archives 

 

I'm not quite sure about your needs, what's the logic for extracting keywords? You may need to create a distinct table column as slicer to filter the field you want to extract first, then create a measure to filter the result you want.

If you can share some sample data and your desired result, we can help you soon.

 

Best Regards,
Community Support Team _ Janey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@AF_Archives , You can create a bar with Word and count of words and analyze ?

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors