PowerBI Dashboard Visualization - How to create visual for average comments on MS form survey

[Omar_204]

Hello,

I am wondering, how can I create a visualization to show the average response for comments from a MS form survey ?

I tried to use the card visualization, but it only takes the first or last response.

I want to be able to see multiple responses (average answer) that users input into the form.

Any help would be greatly appreciated.

Thank you.

[v-yalanwu-msft]

Hi, @Omar_204 ;

Can you share simple examples and a presentation of the results you want to output?

please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Omar_204]

For example, when you have a question in MS forms, it tells you how many responses were submitted and a section for "Latest Responses" , see below.

[Omar_204]

You know how MS forms survey responses show up the average comments for responses with text blown up ?

Is there a way to replicate that in Power BI ?

[Anonymous]

You can use matrix