Target (Budget) with date slicer stay constant

[Anonymous]

Hello,

I have to compare Actuals vs Targets (Planned Calls), but targets are based on specific period (ex. 01 Apr - 30 Sep) and vary by county. I have a date filter (coming from '$Time'[Date]) and Target slicer (from '$Targeting' table). Target values are based on that period, i.e. fixed, but when selecting earlier date on date slicer it shows a proportion. I would like to keep the targets for the whole target period, i.e. not changing even selecting different end date for example. I need something to match the selected period in date slicer and to catch the target inside, because there should be more than 1 target for the whole year for example. Tried with variables (working!) to narrow the calculation only for selected target, but is very slow and fails on some charts (RAM overload). Here is the sample of measure:

------------------------------------------------------------------------------------------------------------

PlannedCalls =
VAR StartDate = MIN ( '$Targeting'[Start Date] )
VAR EndDate = MIN ('$Targeting'[End Date])
RETURN
CALCULATE(SUM( CallsFact[Planned Calls]), '$Time'[Date] >= StartDate, '$Time'[Date] <= EndDate))

------------------------------------------------------------------------------------------------------------

Thank you in advance for ideas 🙂

[v-yuta-msft · Accepted solution]

@Anonymous ,

Click Format-> Edit interactions then click the block icon on the right-top of the visual so that the visual will not be effected by the visual you selected.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.