Word Search Count

[jcastr02]

I know there is a word cloud feature that will tell you the most occuring words, but is there a way to get that information also into a table format?  Like below? 

[v-jayw-msft · Accepted solution]

Hi @jcastr02 ,

Do we have a table contains searched words?

Measure = COUNT('Table'[Column1])

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[harshnathani]

Hi @jcastr02 ,

Have a look at these if it helps.

https://www.youtube.com/watch?v=YOmL57g3RMg

https://www.sqlshack.com/how-to-create-a-word-cloud-generator-in-power-bi-desktop/

https://community.powerbi.com/t5/Desktop/Word-Cloud-Getting-Top-N-Word-Frequency/td-p/714309

https://community.powerbi.com/t5/Desktop/How-to-create-word-cloud-from-a-column-that-has-multiple-va...

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

@jcastr02 

Maybe try a measure?

Measure1 = DISTINCTCOUNT(table[column2])

Then just add the words from the word cloud (column2) in a table visualization, and add Measure1.

Then sort by Measure1.