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:
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?
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
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 () )
Could you please mark the proper answers as solutions?
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
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: