Forum Discussion
Word Search Count
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?
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.
3 Replies
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.
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
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
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.