I have two measure created. Total Project Dollars for the current year and last year. I plot both of them on an area chart by date and it works perfectly. I then calculate cumulative totals for both. The code is here:
Project Cumulative Total = CALCULATE([Total Project], FILTER( ALLSELECTED('Goal Metrics'), 'Goal Metrics'[Dates] <= MAX('Goal Metrics'[Dates])))
The second calculates the on the total last year.
If I put either one on an area chart alone, it works fine. When I put both of them on together…one sits on top of the other and they accumulate. I have no idea what I am doing wrong. If I select just 2019, it filters out all of the 2018 data. I cant keep both of them on the chart.
2019 BI Goals.pbix (114.8 KB)
I don’t know how to upload the chart so I uploaded the PBIX. Driving me crazy…