Sum values based on time slicer for current year

[lezibi]

Hi,

I have actual (red) and plan values (goal) that I want to show in one KPI:

I have a slicer for the months of the current year, so I can change the months to the actual one.

My problem is that I want to show the sum of the values for the whole year up to the current month in the KPI so I deactivated the interactions between time slicer and KPI to get the values of the whole year.

But by doing so, the goal value is the goal for the whole year 2018, but if I chose april 2018 I want to show the goal for 'goal Jan 2018' + 'goal Feb 2018' + 'goal Mar 2018' + 'goal Apr 2018' and not for the whole year in order to compare the actual value in april with my plan for the year until april.

If I filter the trend axis date to the current year, it doesn't work either.

Does anyone know how to solve it?

Thanks in advance!

[v-chuncz-msft · Accepted solution]

@lezibi,

You may take a look at this discussion.

http://community.powerbi.com/t5/Desktop/Relational-Date-Filter-By-Other-Date-How-To/td-p/298373