How do I create a real S-Curve?

[Netrelemo]

I want to create an S-Curve chart. 

Each month has a dollar amount, and each amount can be added to the previous month to give a grouped running total. 

My dataset contains a large number of projects, and a large number of months, and the dollar amount for each. 

The monthly dollar amount is a column. The cumulative amount is a line. Both on the same chart, and obviously there must be two vertical axes. 

So... The cumulative amount can be calculated with a whole heap of code and functions (unlike SAP or Excel which just do it with a single formula), but the graphs don't work. 

Option 1: The standard "line and stacked column" - FAIL. 

The Shared timeline is the whole dataset. So if a particular project has only got three rows of data, the date range will still be selected from all 1 million rows.  

Option 2: line and stacked column chart with table - FAIL

There is no option to have a seondary axis. So the data is not even visible. 

Option 3: Line and Clustered Column - FAIL

Same as option 1. 

Sorry for my obvious frustration, but this is just soooo painful. 

[v-henryk-mstf]

Hi @Netrelemo ,

Can you provide a test data model (delete sensitive information) so that I can do further testing?

Looking forward to your reply.

Best Regards,
Henry

.

[amitchandak]

@Netrelemo , Not very clear, can you share some screenshots of what you need?

[Netrelemo]

I want to create a real one of these. 

The dark blue line is supposed to be cumulative - it only goes up.... except in PowerBI