Year to date Profiled trend line

[GregSibson]

I need to create a trend line on a bar chart that shows what the figures should be at that point in the year, So i have got the data off how many we should have in a year and in excel i would just divide by 12 and times by the current month to work out the profiled number for the year so far. How would i go about doing this in Power BI ? 

[komald]

@GregSibson , try this

choose clustor column chart add year on x axis and values on y axis . and go to visual choose x-axis change type to contineous.

after that go to search bar left to format by selecting cluster column chart and enable the trend line.

I hope this will work for you, if yes mark as a solution. Thanks

[GregSibson]

How do i actually get the data into power Bi though ? I have the data in an excel table but not sure how to put the figures into power bi to then link the trend line too ? So its not a trend line off the data over the year its what the figure should be at so in sales terms we have got 150 sales but at this point in the year we should have 200 and thats what i need to show on the line

[komald]

@GregSibson 

refer these videos
https://youtu.be/LOnXePDb2hQ

https://youtu.be/u-nEn8aolQ8

[GregSibson]

Thanks for the video links doesnt fully answer the query still not sure how to get my own custom made trend line on the graph