Set targets on graph?

[KelvClark]

Hi all,

I'm new to Power BI so was after some help with targets. Any help would be greatly appreciated.

I currently have a graph showing totals per group over the last 4 years + current year to date. I would like to  add a target line in the table which would start at 2013, this target would be calculated by taking the average of this group over a 4 year period (2012/13/14/15), every year after this would be 6% year on year.

I have already worked out the targets for each groups and created the separate table. I have a column in the graph data table and target table to link together but can't see how I would link the target data in to the graph on specific group and year. 

Is there a way I can calculate Targets on the fly?
Can I add targets to a table from a different data set?

Thanks in advance.

[nedthai]

Dear @KelvClark,

I really care about the problem you are having, but I still not understand it clearly.

Could you please describe the problem more clearly with a more detailed illustration (by image).

When understand more your problem, I hope I can support you.