Forum Discussion

Sam_Jain's avatar
Sam_Jain
Helper 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
Super User
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

Sam_Jain's avatar
Sam_Jain
Helper III
3 years ago

Hello Phil,

 

Thank you so much for the response and appreciate you sending over a test scenario.

 

Let me try to be a little more clear on the dataset i have and what i am trying to achieve.

I misspoke when i said survey, this is more of a review on a monthly basis with a checklist of about 100 odd questions on a form. True/False are the responses.

  • Unique Identifier Key - This i plan to use to tie to another file whicha has more attributes / dimensions for slicing and dicing
  • 100 odd questions - For example - Do you have an account with us - True / False
  • Date when it was submitted (important because it has to be done within a deadine)

Now what i want to be able to look at is - If i select the Unique ID - (tied with attributes such as name, location, etc) for a specific period say the month of March

Then i want to see what were all the responses from the ID - ideally a filter where i can select the question and it would show me whether it was answered T/F 

Additionally i can also group it by say location and it would show me all the responses for that specific qn.

 

Please let me know if this makes any sense!

 

I tried to unpivot but was unsuccesful in doing so maybe because i need the data with a granularity of per id per month per row.

 

Thanks.

Again, appreciate all your help.