Cumulative Actual till Selected date in slicer.pbix (65.0 KB)
Project Description
I have created dummy Project with two phases Engineering & Construction.
Engineering & construction have weightage 60 % & 50% respectively.
I have table with Plan & actual week wise progress for each phase.
For overall progress calculation, we need to multiply progress at phase level with above weightages.
Dashboard Description
I want date slicer (drop down +single select) at week & month level.
The last Friday is week cut-off
There are 2 visuals
- Matrix- To show all phases and progress on selected week or month cut-off
- Line & Clustered Column Chart- To show month & week wise values of plan actual at week & cumulative level
Requirement
In Line & Clustered Column Chart, I want to show Actual Values (week & Cumulative) only till the cut-off selected in date slicer.
Presently, Actual values are showing till end of project as I have selected Edit interaction between Date Slicer and Line & Clustered Column Chart to none.
Thanks in Advance