topic Re: Is it possible to analyse and sum up text data ? in DAX Commands and Tips

Is it possible to analyse and sum up text data ?

Romain_S — Thu, 30 Nov 2023 10:10:47 GMT

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

tackytechtom — Thu, 30 Nov 2023 16:03:43 GMT

Maybe a word cloud can help you here? 🙂

Let me know if this helps!

Romain_S — Fri, 01 Dec 2023 08:17:51 GMT

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