Year to Date Chart

[smithmc3]

So do you all know how to make it so that the actual only shows through the current month?  See below, top chart is the publication and the bottom on is the powerbi chart?  I put the code for how we calculate actual and planned.  Target is calculated the same as planned and the multipled by .77

Actual = 
CALCULATE(
	SUM ('Months'[ActualPlanned]),
	FILTER(
		ALLSELECTED('Months'[Title]),
		ISONORAFTER('Months'[Title], MAX('Months'[Title]), DESC)
	)
)

Planned = 
CALCULATE(
	SUM ('Months'[AllPlanned]),
	FILTER(
		ALLSELECTED('Months'[Title]),
		ISONORAFTER('Months'[Title], MAX('Months'[Title]), DESC)
	)
)

[Eric_Zhang · Accepted solution]

@smithmc3

So you'd like the actual measure shows as in the top chart? I mean the red line shows blank after Sep instead of a horizontal line? If so, you could try

Actual =
VAR val =
    CALCULATE (
        SUM ( 'Months'[ActualPlanned] ),
        FILTER (
            ALLSELECTED ( 'Months'[Title] ),
            ISONORAFTER ( 'Months'[Title], MAX ( 'Months'[Title] ), DESC )
        )
    )
RETURN
    IF ( MAX ( 'Months'[Title] ) <= TODAY (), val, BLANK () )

If this is not your case, could you post any sample data? Do mask sensitive data before posting.