Line and Clustered Column Chart Conditional Filter on X-axis

[gabrielmission7]

Hello! I'm using Line and Clustered Column Chart, and am struggling to display blue bars from Jan to Dec (ie. all bars) but only show red line until April (ie. Jan to Apr) and nothing beyond April. Is there a way to do such conditional filter? Thanks!

[sevenhills]

Without knowing the details of DAX and sample data, data model, it is tough to answer.

One best guess is add a new measure to cut off at April or modify the existing measure:

Just giving an idea of the measure to filter up to previous month:

Calculate (Sum('Table'[Amount]), FILTER('Table',MONTH('Table'[date]) < MONTH(now())))

If need to hard code, then replace MONTH(now()) as 4.