Add a budget line to a line chart

[Apple08]

Hi All

I have a line chart with forecast and actual across the 12 months in a financial year, and this line chart can be updated by a project name slicer.  I would like to add in the budget showing as a target line in the chart, however the budget only shows as a dot rather than a line across the 12 months (as it is only a budget field for the whole year instead of breaking down for the 12 months).  I wonder is there any way I can show the budget line across the 12 months?  Many thanks.

[themistoklis · Accepted solution]

Hello @Apple08 ,

Maybe you are referring to a refernce line on a chart. 

To do that go to 'Analytics' section of the chart. See image below:

[Apple08]

Fantastic!  It is exactly what I want!  Many thanks!