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.

     

     

     

     

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous ,Can you share sample data and sample output in table format?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    This is currently being used as real-time data, so I have created my own data set in BI.  Have selected the 'streaming dataset' option. Does that make sense?

      • 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.