Hello All,
I want to create a line and cluster chart to compare Actual, Forecast, and Budget. The measure returns the desired result when placed in the line y-axis with actual revenue measure. However, I would like to differentiate the Actual result in colors from the forecast when the measure is placed in the clustered column y-axis.
Actual and Forecast =
var _lastSales =
CALCULATE(MAX(Revenue[Month Year]),
REMOVEFILTERS(‘Date’)
)
var _Actuals = [Revenue Actual]
var _Forecast = CALCULATE( [Revenue Forecast],
KEEPFILTERS(‘Date’[Date] >=_lastSales))
var _result =_Forecast + _Actuals
return
_result