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.
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.
sorry....still no trend line....
ReplyDeleteCan you specify the problem a bit? May be it's due to the column data type
DeleteSometimes 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
ReplyDeleteWhen 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.
ReplyDeleteSame issue with me. How to solve it ?
DeleteSame issue, anyone get the solution of it, pleas share.
Deleteyou guys probably don't have a calendar table
DeleteHad 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
DeleteI don't even see the option to change the x-axis
ReplyDeleteNo 'Type' under X axis either
ReplyDeleteHi Nancy,
DeleteCan you specify the problem a bit? It depends on column type as well.
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.
ReplyDeleteI 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.
ReplyDeleteThanks for the comment..Definitely it helps
DeleteGreat learning experience with proficient trainers in Informatica. Flexible timings with hands on experience with real time scenarios.
ReplyDeletePower Bi Training in Bangalore
Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
ReplyDeletePower Bi training in bangalore
Power Bi institutes in bangalore
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
ReplyDeletePower 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.
ReplyDeleteWow 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!
ReplyDeleteVisit here for Product engineering Services.
Hello!
ReplyDeleteif 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?