The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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:
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
157 | |
106 | |
96 | |
83 | |
75 |
User | Count |
---|---|
153 | |
137 | |
131 | |
81 | |
61 |