Forum Discussion
Trend line from multiple choice question in Forms
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.
Ah, that sounds like it will solve my issue.
Can you please explain/show where and how i set the trend line measure?
Super UserRight 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.
Thank you!
Now I got 12 fine charts with green, yellow and red lines 😎