Forum Discussion
trndlnd
2 years agoFrequent Visitor
Trend line from multiple choice question in Forms
Hi! I have a Form with 12 multiple choice quiestions. Every answer have the options "Green", "Yellow", "Red" and "Other". For some questions you can select up to two answers (Usually a colour an...
- 2 years ago
Right click on your column and choose New Measure.
Paste in the code about but replace the [Your Calculation] with your Count calculation that you dragged in to the visual. I imagine it will be something like Count(Table[Column]).
Feel free to share a screen shot of what you have including the Field well.
trndlnd
2 years agoFrequent Visitor
Ah, that sounds like it will solve my issue.
Can you please explain/show where and how i set the trend line measure?
SamWiseOwl
Super User
2 years agoRight click on your column and choose New Measure.
Paste in the code about but replace the [Your Calculation] with your Count calculation that you dragged in to the visual. I imagine it will be something like Count(Table[Column]).
Feel free to share a screen shot of what you have including the Field well.