Forum Discussion
Year to date Profiled trend line
Helper IGregSibson , 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
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
refer these videos
https://youtu.be/LOnXePDb2hQ
https://youtu.be/u-nEn8aolQ8Thanks for the video links doesnt fully answer the query still not sure how to get my own custom made trend line on the graph