Forum Discussion
How to make line chart end?
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!
4 Replies
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 __ResultGreg_Deckler I'm still learning all the language - could you help me out if I provide my report and data files?
AlexJ01 That's usually the fastest way to victory.
