cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BorisV Frequent Visitor
Frequent Visitor

Target (Budget) with date slicer stay constant

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 🙂

 

Target.png

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Target (Budget) with date slicer stay constant

@BorisV ,

 

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.

1.PNG 

 

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.

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: Target (Budget) with date slicer stay constant

@BorisV ,

 

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.

1.PNG 

 

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.

View solution in original post

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors