Is it possible to analyse and sum up text data ?

[Romain_S]

Hello, 

I'm (really) new to Power BI, so maybe this question has already been answered, but I can't seem to find any easy answer.

The situation :

We're using MS Forms to ask students for their satisfaction.

Responses are written into a SP List which I'd like to use in Power BI

No problem with choices questions, analysis works fine.

But we also have open questions were students can enter text to add explainations about their previous answers.

(e.g. : if you answered No to that question, please tell us why : .....).

Is there a (simple) way to sum those text answers up and highlight the major points that should be taken into account ?

Smart Narrative seems to be unable to treat text data.

Maybe I'm not using the proper solution... 🤔

Thanks for your help

Best regards,

Romain_S

[Romain_S]

Hi @tackytechtom 

thank you very much, that's exactly what I was looking for. 

I thought I'd had to go through complex programming with Azure but it seems this Visualization will do the job perfectly.

Now I just need to fix the rich text information issue to get rid of parasite words and strings (maybe something to check in my SP list column type).

+ Your blog might be really useful as well.

Best regards 

[tackytechtom · Accepted solution]

Hi @Romain_S ,

Maybe a word cloud can help you here? 🙂

How to Create Word Cloud in Power BI - Zebra BI

Let me know if this helps!

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/