Cumulative total Changes addition order with date hierarchy axis

[Harry]

Hi, 

I am trying to create a combined column & line chart. Columns will show incoming/outgoing money per month and cumulative total shown by line. 

I would like to have date hierarchy to show bars in month totals but when i do this, it changes the cumulative total to something

that is not the correct addition. 

I want the bars to show as they do in the top coloumn but the cumulative total is not correct like this, the cumulative total should look like the second graph. How do i achieve this? 

Thanks in advance for the help.  

[v-chuncz-msft]

@Harry,

Based on my experience, you may try ALLSELECTED Function and take advantage of Show Categories With No Data.

[Harry]

I forgot to add, when I change to cumulative total it extends the X axis to include all of 2017 and 2018 which is not needed due to their being no incomings or outgoings here