topic Stop Line Chart at end of previous quarter in DAX Commands and Tips

Stop Line Chart at end of previous quarter

senorbol — Thu, 19 Aug 2021 08:29:25 GMT

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.

Re: Stop Line Chart at end of previous quarter

lbendlin — Thu, 19 Aug 2021 22:55:25 GMT

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.

Re: Stop Line Chart at end of previous quarter

senorbol — Fri, 20 Aug 2021 07:47:43 GMT

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])

)))

Re: Stop Line Chart at end of previous quarter

lbendlin — Fri, 20 Aug 2021 13:39:12 GMT

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())