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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.