Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors