Cumulative line chart break

[Anonymous]

Hello,

I'm trying to make a cumulative chart with this code:

YTD GP = CALCULATE(
    SUM(BIPER[GP]),
    FILTER(
        ALLSELECTED(BIPER),
        BIPER[Invoice Date] <= MAX(BIPER[Invoice Date])
    )
)

and the result shown like this:

The line for YTD GP breaks when there is no data for that day. I set X-axis type to 'Categorical' because when I set to 'Continuous', the chart looks more weird and unreadable.

Is there any other way that I can fix this in Format or DAX?

Thank you.

[parry2k]

@Anonymous add +0 to your measure

try this
 
Same Business Day Sales PY = 
VAR __currentBusinessDay = MAX ( Calendar[BusinessDay] )
RETURN
CALCULATE (
SUM ( Table[Sales] ),
DATEADD ( Calendar[Date], -1, YEAR ),
Calendar[BusinessDay] = __currentBusinessDay
) + 0

[Anonymous]

It gets worse

[parry2k]

@Anonymous i didn't notice that you are not using date dimension. It is recommended to add date dimension and use that for this calculation instead of using date from your transaction table. there are many posts on how to add date dimension in the model.

[Anonymous · Accepted solution]

Actually I already has date dimension. The reason I use the current table's date is because I designed the goal for every working day at my company. So if I use the date dimension, the line for Goal will break. 

I already find the solution and it works. So here's my new measure:

YTD GP = 
IF(MAX('CALENDAR'[Date])>TODAY(), BLANK(), 
    IF(MAX(ST[Date])=BLANK(), BLANK(),
        CALCULATE(
            SUM(BIPER[GP]),
            FILTER(
                ALLSELECTED('CALENDAR'),
                'CALENDAR'[Date] <= MAX('CALENDAR'[Date])
            )
        )
    )
)

Anyway, thank you @parry2k !