Line chart extends to next month when next month value data is not present

[Anonymous]

Hi guys.

I am bit puzzled by a line chart extending out to next month when the next month value is not present.

The chart below shows Month-To-Date Actual (Bar) with Actual Cumulative (Line) in Jan 2020. There is not December and other prior month data so Jan only appears. What is interesting is that Feb appears in the Line Chart as if it is zero. In reality, Feb does not have any data just line Dec and prior months. 

The following measures are used:

MTD Actual = IF(sum('Fact Summary'[MTD Actuals])=0, BLANK(),sum('Fact Summary'[MTD Actuals]))

Actual Cumulative =

VAR ActualCumAdj =

CALCULATE(

SUM('Fact Summary'[YTD Actuals]),

FILTER(

ALLSELECTED('DimDate'[FIN_YR_MONTH]),

ISONORAFTER('DimDate'[FIN_YR_MONTH],

MAX('DimDate'[FIN_YR_MONTH]),

DESC)

)

)

RETURN

if( ActualCumAdj = 0, BLANK(), ActualCumAdj)

How can I stop showing the Feb for the chart? I am assuming that the Actual Cumilative (line chart) is causing this but it may be MTD Actual that is causing this.

Let me know your thoughts, Jedi masters.

Thanks.

[v-lili6-msft]

hi @Anonymous 

I have test on my side, it works well.

Could you please share your sample pbix file for us have a test, there should be something wrong in other.

Regards,

Lin

[kentyler]

Have you checked to see which values are in FIN_YR_MONTH ?

[Anonymous]

Yeah. It is just simple month and year.