How to Create a Simple Cumulative Line Chart

[Anonymous]

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

[johncolley]

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!

[Anonymous]

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

[johncolley · Accepted solution]

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!

[Anonymous]

@johncolley 

You are a scholar and a gentleman.

It works!!!!

Thanks so much fo ryou rkind guidance