Stop Line Chart at end of previous quarter

[senorbol]

Hi All, Wondered if someone had some knowledge on the following use case. 

I have a bar over line chart that is in quarters and years - I want to stop the green line chart element at the end of the previous quarter to one we are currently in. Using the screenshot below - at the moment we are in Quarter 3 2021 - I would like the line chart to stop at Q2 2021 - and then going forward when we move into Q4 2021 I would like the line chart to stop at Q3 2021 and so on...

I'm not sure if this is possible but any help/advice would be really appreciated.

[senorbol]

Hi @lbendlin - thanks so much for the reply. I use a measure at the moment to draw the line. I'm using the following calculation - any tips on how I can amend this to get the desired result? 

Cumulative Actual Calc  =

IF( MINX( 'M Calendar', [Date]) <= TODAY(),

CALCULATE(SUM('Master Data 2'[Actual_Final_Decom]) + SUM('Master Data 2'[Actual_Final_Migration]) ,

FILTER( ALLSELECTED ('M Calendar'), 'M Calendar'[Date] <= MAX('M Calendar'[Date])

)))

[lbendlin]

I would write it differently.

Cumulative Actual Calc  =
IF( MIN('M Calendar'[Date]) <= TODAY(),
CALCULATE(SUM('Master Data 2'[Actual_Final_Decom]) + SUM('Master Data 2'[Actual_Final_Migration]) ,BLANK())

[lbendlin]

Do you use a column to feed the line , or a measure?  You would want to use a measure, and set the return value to BLANK() for the periods where you don't want the line to draw.