How to make line chart end?

[AlexJ01]

Hi there,

I have created some running total measures (count vs date) for a cummulative line chart which looks like this:

I've got a separte date table which has been used to create the measures:

The issue I have is that the blue and purple lines have no data past about July, so I'd like those lines to end there, but I can't seem to do it without breaking them. Basically I want it to look like the below:

Any help would be appreciated!

[Greg_Deckler]

@AlexJ01 So, going to be a bit dependent on exactly how things are configured in your model but perhaps something like this:

Blue Line RT =
  VAR __Measure = [Blue Line Running Total Measure]
  VAR __Count = COUNTROWS( 'Block 5 )
  VAR __Result = IF( __Count = BLANK(), BLANK(), __Measure )
RETURN
  __Result

[AlexJ01]

@Greg_Deckler  I'm still learning all the language - could you help me out if I provide my report and data files? 

[Greg_Deckler]

@AlexJ01 That's usually the fastest way to victory.

[AlexJ01]

Thanks @Greg_Deckler  I've uploaded a simplified version of my report & data source file to this WeTransfer link: https://we.tl/t-DSWRWvEpLG