Forum Discussion
Visualisation of Real Time Data through Forms
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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserAnonymous , I am not clear on the problem you are facing. In case you want to write back. refer -https://www.youtube.com/watch?v=LxuRzj0X348
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-msftCommunity Support
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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.