Set targets on graph?

KelvClark — Tue, 05 Dec 2017 19:56:21 GMT

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.

Re: Set targets on graph?

nedthai — Thu, 07 Dec 2017 01:23:59 GMT

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.

topic Re: Set targets on graph? in Report Server

Set targets on graph?

Re: Set targets on graph?