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.
Thanks for the reply!
I have already split the Columns by a delimiter, but into column, so that I can extract and display the comments from the answers. So now the colours are in one column and the comments (free text) is in the other, for all 12 questions.
I think I've found a way to do the trend line, but it just shows when there is data in the cells, and. If there is no data after last tuesday, the line just stops "in the air" that date. I want the line to go to zero when there is no data.
An easy way to do this?
Super UserHi trndlnd the trend line can be set based on a measure.
Measure to 0 = If( isblank([Your calculation]), 0, [Your calculation]))
Ah, that sounds like it will solve my issue.
Can you please explain/show where and how i set the trend line measure?
- SamWiseOwl
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.
Thank you!
Now I got 12 fine charts with green, yellow and red lines 😎