The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
78 | |
74 | |
43 | |
32 | |
28 |
User | Count |
---|---|
104 | |
93 | |
51 | |
51 | |
46 |