Forum Discussion
undefined
akhassim Your datamodel need to contains a Date field that is used as the X-axis, and that it is properly sorted in ascending order. And this date filed should be common to both the Earned value and Actual cost.
To calculate a flag that determines whether to show the Actual cost data, you need to create calculated column in your data model. This column will be used as a filter in your visuals.
ShowActualCost =
IF (
[Date] <= MAX ( 'YourTable'[Date] ),
"Show",
"Hide"
)Create your line and clustered column chart as you said, with MMM yyyy on the X-axis and add planned Value and Earned value to the Clustered column Y-axis and add Actual cost to the same clustered column y- axis.
By using showactualcost calculated column as a filter, you will control visibility of the Actual cost data based on the selected date. It will stop at the same date as the last Earned Value line.
akhassim Your datamodel need to contains a Date field that is used as the X-axis, and that it is properly sorted in ascending order. And this date filed should be common to both the Earned value and Actual cost.
To calculate a flag that determines whether to show the Actual cost data, you need to create calculated column in your data model. This column will be used as a filter in your visuals.
ShowActualCost =
IF (
[Date] <= MAX ( 'YourTable'[Date] ),
"Show",
"Hide"
)
Create your line and clustered column chart as you said, with MMM yyyy on the X-axis and add planned Value and Earned value to the Clustered column Y-axis and add Actual cost to the same clustered column y- axis.
By using showactualcost calculated column as a filter, you will control visibility of the Actual cost data based on the selected date. It will stop at the same date as the last Earned Value line.