Forum Discussion
How to Create a Simple Cumulative Line Chart
Hi Anonymous , Apologises a step I didnt mention is you'll need to sort the month year column by monthyearno. When you click on Month Year a Column tools bar should appear at the top:
You can sort the axis of the visual by selecting the more options button in the top right of the visual.
If this answer solves your problem please mark it as a solution!
Hi johncolley
Many thanks for the prompt reply.
It looks like I am nearly there following your example.
I replicated the columns and measures and as you can see the chart is getting there.
I am not sure why the chart is reversed though and the x-axis out of order.
I created the 'Date' table ('Date Limited' in my case)
And created the measures in the ID (LL List in my case) table
Any thoughts on the chart order by chance?
I have compared mine to your example and it all seems in order.
Of note, I am in Australia and the date format is typically dd-mm-yy, or variations of that syntax. Not sure if that is a factor
Cheers again
Hi Anonymous , Apologises a step I didnt mention is you'll need to sort the month year column by monthyearno. When you click on Month Year a Column tools bar should appear at the top:
You can sort the axis of the visual by selecting the more options button in the top right of the visual.
If this answer solves your problem please mark it as a solution!