Visualization for Text Responses

[Anonymous]

Hi all,

I'm brand new to Power BI but excited to learn and hope to do great things. (I apoligize in advance if I use incorrect terminology or provide unnexessary details). My agency currently deploys surveys at the end of each of our classes; reports which I can pull in Excel so use that as my data source. The questions vary between numerical rating scale and open-ended responses. We also use the Kirkpatrick Four Levels of Training as a base for our survey, so I have several queries/tables so far: one for demographics and one for each Kirkpatrick level. I was able to get the demographic visualizations done without an issue because they were all numerical responses and worked well with pie and bar charts. The others, however, are a mix of numerical numbers and text responses, and I can't figure out the best visualization to use to capture all this data.

For example, my Level 1 table contains answers from 17 respondents. There are eight questions with numerical responses (i.e. "I would recommend this course to others" on a scale of 1-5) and four with text responses (i.e. "What aspect of the course was most valuable to you?")

How can I get one visualization that captures all 12 of these questions and their varied response formats?

[v-chenwuz-msft]

Hi @Anonymous ,

The point of "I would recommend this course to others" on a scale of 1-5 is the value of this scale. Splitting numbers in Power Query and displaying them in a bar chart is the best way.

Split columns by delimiter - Power Query | Microsoft Docs

For the text responses, Word Cloud is recommended.

Find the right app | Microsoft AppSource

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.