Cumulative Cost Measure - Line Graph Stop Flat Lining Out
Hi there! I have created a cumulative cost measure within one of my reports which is cumulating cost values over a 15 year period however I am not so happy with the visual which I will explain. My data is split into 3 Cost Types (Legend) - Earned, Planned, To Go. All three are showing fine on the line graph & 'Planned' will remain the same and show the trajectory over the 15 year span, however my value for 'Earned' is projecting until the current reporting month and then it is just flatlining as the cumulative value is remaining the same. I want this line to stop on the reporting month and when nothing further is cumulating to the 'Earned Value'. Also on the 'To Go' Value this works in the opposite and is only starting to project from the reporting month, and flatlining at 0 up until then so I would really want this line to not show until the reporting month and start projecting from there onwards. Any tips and suggestions would be greatly appreciated, below is the current DAX I am using to cumulate my values. Cumulative Cost = CALCULATE( SUM('EV Data Pivot'[Month Value]), FILTER( ALLSELECTED('EV Data Pivot'), 'EV Data Pivot'[Month] <= MAX('EV Data Pivot'[Month]) ), VALUES('EV Data Pivot'[Control Account]), VALUES('EV Data Pivot'[Cost Type]) ) ----- (Also may be worth noting I have replaced my date hierarchy on X Axis with a custom dateTable relationship for text values for FY, Quarter, Month to align with financial year reporting.)
