Forum Discussion

Omar_204's avatar
Omar_204
Helper I
4 years ago

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

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.

Need Help
Tips and Tricks
Tutorial Requests

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    You can use matrix

  • Omar_204's avatar
    Omar_204
    Helper I
    4 years ago

    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 ?

  • Omar_204's avatar
    Omar_204
    Helper I
    4 years ago

    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.

     

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    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.