How to Add a Trend Line in Power BI Chart

The trendline does not come as a default option in Power BI and in this tutorial, I will show you, how to add a trend line to Power BI chart.

Step 1: Download the Vehicle profit information Excel sheet.

Step 2: Step up it in Power BI



Step 3: Now if you want to add the trend line to the chart - Note: it will not appear with the default settings 


Step 4: To add a Trend line- First change the X-axis - Type to "Continuous" 


Step 5: Now as you see the Analytics tab - Trend line will appear. 


Here is the output with Trend Line, 


There are some other common errors as well, which leads to disappear the Trend line, One is: Not having correctly formatted Y-Axis (Date/Number etc.)

If you get more issues, please comment here.

Comments

  1. sorry....still no trend line....

    ReplyDelete
    Replies
    1. Can you specify the problem a bit? May be it's due to the column data type

      Delete
  2. Sometimes we have to face a lot of confusion when we found different opinion of different hundreds of articles related to same question. But I think now I am close to resolve my doubts after reading this blog.https://forexgo.co

    ReplyDelete
  3. When I try to change the X axis to Continuous from Categorical it changes back to Categorical. I have months on the X axis. Really frustrating.

    ReplyDelete
    Replies
    1. Same issue with me. How to solve it ?

      Delete
    2. Same issue, anyone get the solution of it, pleas share.

      Delete
    3. you guys probably don't have a calendar table

      Delete
    4. Had the smae issue here, and just changed the column type to date. To do the months I just add a "/01" to the month and year field so it appears now as "2020/10/01" and so on for every month. And now, with the column type as DATE and Months like this it works

      Delete
  4. I don't even see the option to change the x-axis

    ReplyDelete
  5. Replies
    1. Hi Nancy,
      Can you specify the problem a bit? It depends on column type as well.

      Delete
  6. Still cannot get trend line. When I try to change the x-axis to continuous it won't let me and it immediately resets it to categorical every time.

    ReplyDelete
  7. I tried to do this with a Line Chart, but Trend never showed. When I switched the chart to Clustered Column, I was able to add a Trend Line. I also made sure my source data was Number. Maybe that helps someone.

    ReplyDelete
  8. Great learning experience with proficient trainers in Informatica. Flexible timings with hands on experience with real time scenarios.
    Power Bi Training in Bangalore

    ReplyDelete
  9. Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
    Power Bi training in bangalore
    Power Bi institutes in bangalore



    ReplyDelete
  10. The blog was having very informative content and very useful for me. Well done post and keep it up... Thanks for sharing such a Useful info. tableau automation

    ReplyDelete
  11. Power BI Themes A very awesome blog post. We are really grateful for your blog post. You will find a lot of approaches after visiting your post.

    ReplyDelete
  12. Wow admin! An amazing way to help people. You have shared a very useful post I really love it keep going on, thanks for sharing such a wonderful post with us. I wanted to thank you for this websites! Thanks for sharing. Great websites!
    Visit here for Product engineering Services.

    ReplyDelete
  13. Hello!

    if you are having issues with the trendlines. Please ensure you have a separate calendar table with a continuous date from Jan1-Dec31. Do a 1 to many relationship to YOUR date column. Then pull in the date field from the Calendar table. However, when doing this it created a hierarchy and It only displays the trendline option on a year level but when drilling down to the month level the trendline option disappears. Why?

    ReplyDelete

Post a Comment