Creating Report from Survey

[Charles-NCEC]

Hello,

I am wondering how to create a report that displays this situation correctly. I have a dataset that is from a survey. The two fields of data I am using is the "Question" and then the "Respondents Answer" on a rating of 1-5. When trying to display this in a report it just sums up the total for the 1-5 answers for all users combined. I am trying to see for example, how many users answer 4 for a certain question etc. Please let me know if you need additional explanation.

[Idrissshatila · Accepted solution]

HEllo @Charles-NCEC ,

check if any of these helps https://www.youtube.com/results?search_query=visualize+survey+data+power+bi+

[Anonymous · Accepted solution]

Hi @Charles-NCEC ,

You can add the point column into the slicer.

Or you can create a measure.

Measure = CALCULATE(COUNT('Table'[customer]),FILTER(ALL('Table'),'Table'[point]=SELECTEDVALUE('Table'[point])))

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

[Idrissshatila · Accepted solution]

HEllo @Charles-NCEC ,

check if any of these helps https://www.youtube.com/results?search_query=visualize+survey+data+power+bi+