Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Visualisation of Real Time Data through Forms

Hi. I have tried looking for the answer everywhere but still do not know what I am doing incorrectly.   I have created a survey through Microsoft Forms that respondents will answer. I am hoping to ...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    I have a sample table like this.

    1. 

    2.Unpivot the column

    3. Remove the useless column.

    4. Create a measure.

    Number of selection = COUNT(Sheet6[Value])

     

    Best regards,
    Lionel Chen

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

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi @amitchandak thanks for your help. I have atached my question here. As you can see, when I visualise it in a table, these are the response I get. When visualised in a bar graph it has put the responses together (so if a respondent has mentioned a stress being physical/mental, it has put them together. I would like one bar (section) for each stressor. So the graph will show that 2 respondents have selected physical health, 2 respondents have chosen family for e.g.

 

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Anonymous ,

 

I have a sample table like this.

1. 

2.Unpivot the column

3. Remove the useless column.

4. Create a measure.

Number of selection = COUNT(Sheet6[Value])

 

Best regards,
Lionel Chen

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