Forum Discussion

GregSibson's avatar
GregSibson
Frequent Visitor
4 years ago

Year to date Profiled trend line

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 ? 

Need Help

4 Replies

  • komald's avatar
    komald
    Icon for Helper I rankHelper I
    4 years ago

    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's avatar
      GregSibson
      Frequent Visitor
      4 years ago

      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