target lines to dynamically increase by 1% each month

[Anonymous]

Hello,

Is it possible to create a target line in a line and graph chart which increases by 1% each month?

Thanks.

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

If you mean to add such a line in a line chart, you could refer to my test below.

base date = DATE(2019,9,1)

base target = 3

increase month = DATEDIFF([base date],TODAY(),MONTH)

increas target = [base target]*(1+[increase month]/100)

If 

base date = DATE(2019,8,1)

Then [increase month] will be 2

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[kentyler]

If you know the start month, let's say its Jan.

Then you can create a calculated column that divides the month number of the date by 100, which will give you .2, .3, .4 for feb mar and april etc

Then you can add that column to your graph

[Anonymous]

Hi @kentyler ,

Would you be able to explain it in detail? That would be great.

Thanks

[kentyler]

Do you have time to do a screen share today ? I usually use Zoom. Then we can go over your problem in detail.