Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
We looking for frequency of words is our customer queries, looking for trends/patterns. The obvious visualisation to use world be Word Cloud.
This is helpful but I don’t what to have to drag my mouse over the word to see how many time the word appears.
We looking for frequency of words is our customer queries, looking for trends/patterns
Ideally, I would like to be able to view the top 10 to 20 words that are appearing in my data. Something like this:
100 Scale
99 Printed
50 Maps
30 Downloading
20 Geology
20 Digital
20 Grid
19 Issue
10 Topographic
5 Problem
I have looked for other examples and they get pointed to here: Power BI, Text Analytics and the United States Congress
I can do some very simple coding with Power BIs scripting this is a little complex for me to replicate/use.
Can anyone point me in a direction of visualisation that might suit my needs or some simpler coding to explore?
Hi @steambucky,
Could you please mark the proper answers as solutions?
Best Regards,
Dale
Hi Affan,
I coulnd see a way to upload a CSV so this is the type of data we would be looking at
--
test data 1
--
Phone call advised he has inadvertantly ordered the same product twice as he deleted the wrong plan from the payment cart as it had been held over from his purchase yesterday. He would like a refund. He also expressed that he would like other searches to be made available eg Historical titles and plans etc
--
test data 2
--
Hi @steambucky,
You can upload it to the cloud drive like OneDrive then share the download link here. Please mask the sensitive parts.
The key point here is how to transform the original data into a reasonable format. Please refer to the demo below.
1. If all the words are columns, we can transpose it.
2. Create a measure like below.
Measure = VAR ranks = RANKX ( ALL ( word[Column1] ), CALCULATE ( COUNT ( word[Column1] ) ) ) RETURN IF ( ranks <= 3, ranks, BLANK () )
Best Regards,
Dale
Apologies for late reply - i have been on extended sick leave.
I have implemeneted the code you have suggest and it isnt creating the desired result. My desired result is a list of words and count of the times they apear in the data
eg:
5 Ordered
7 Title
4 Cart
etc
Is my request actually beyond the scope of calculated columns, and what i actually need is spec
You can find my files here: One Drive:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |