Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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?
Solved! Go to 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.
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.
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)
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.
User | Count |
---|---|
82 | |
79 | |
68 | |
46 | |
46 |
User | Count |
---|---|
105 | |
44 | |
39 | |
39 | |
39 |