Monthly target line on graph

I would like to add a target line to a chart, where the target would be set differently depending on the Month.
So for example. for the month of January the target is 5, for February it is 9, for March it is 10 and so on…
Is it possible to do this using CASE ? Or any other way?
I have set goal lines in the past by defining a new calculated measure and adding one number to it. That works well where the monthly target is always the same.

Any help would be appreciated.
Thanks

Hi,

Yes, you could create a new calculated measure using CASE WHEN… THEN…END

Note that you could approach Month by this formula

CASE 
WHEN
[Time].[Month].currentmember.key = 1
THEN
10
WHEN
[Time].[Month].currentmember.key = 2
THEN
12
END

That should set the goals for January and February

Try the solution described in this community post:

Martins / eazyBI support

1 Like

Thank you Martins,
This solves my problem exactly.

1 Like