Week & Cumulative Actual till Selected date in slicer

DAX DAX Calculations
1

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

2

Hi @prafullchavan1 ,

For your Line & Clustered Column Chart to show Actual Values only up to the selected cut-off date in the date slicer, try the following steps:

  1. Create a measure that calculates the cumulative actual values up to the selected date.
  2. Use the new measure in your Line & Clustered Column Chart.
  3. Ensure the date slicer interactions are set correctly to filter the chart based on the selected date.

If you need more detailed guidance, you can try running a query on the Data Mentor platform for further assistance.

Cheers,

Enterprise DNA Support Team