Forum Discussion

Sam_Jain's avatar
Sam_Jain
Icon for Helper III rankHelper III
3 years ago
Solved

Text Responses Visualization

Hello Community,   I have a dataset which is essentially responses on a survey! For every row there are responses in terms of True/False (Checklists on Form) and each column is a question asked.  ...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    3 years ago

    Hi Sam_Jain 

     

    Download example PBIX file

     

    Without your actual data I'll have to make up my own so starting with this

     

     

    Then Unpivot, Group and Sort the data to get this

     

     

     

    Which can be visualized like this.  Use the slicer if you only want to see the data for 1 question at a time.

     

    Don't use a pie chart.  It's hard to gauge value easily with pies.

     

     

     

     

     

    regards

     

    Phil

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
3 years ago

Hi Sam_Jain 

 

Can you please supply some sample data otherwise I'l have to try creating my own and there's no guarantee I'll get it looking exactly like yours.

 

Regards

 

Phil

Sam_Jain's avatar
Sam_Jain
Icon for Helper III rankHelper III
3 years ago

Hello Phil,

 

Here's a snapshot of how the data is -

 

 Please let me know if this works.

 

Thanks.