Forum Discussion
Creating Report from Survey
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.
HEllo Charles-NCEC ,
check if any of these helps https://www.youtube.com/results?search_query=visualize+survey+data+power+bi+
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
HEllo Charles-NCEC ,
check if any of these helps https://www.youtube.com/results?search_query=visualize+survey+data+power+bi+
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.