Forum Discussion
How to Create a Simple Cumulative Line Chart
Hi All
I am new to the forum and PowerBI in all honesty
I am wanting to create a simple cumulative line chart for my data
I have a table of 6 records (as below) captured over several months. Some months with more than one record
I want to show a chart x-axis months and y-axis count of the records captured and watch it grow.
I have no idea where to start.
What I am hoping to achieve is something like I created in Excel below to dummy up the look
Thanks in advance
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!
4 Replies
Hi Anonymous ,
Please see the sample pbix here: https://www.dropbox.com/s/i8htrv2v6zij8r2/cumaltive%20total.pbix?dl=0
Basic approach for this is:
- Create a date table to use as the x-axis
- Create a measure to cumaltive count ID's to use as the y-axis
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!