Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Set targets on graph?

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.

Regular Visitor

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.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!