Forum Discussion
How to add Trend line in Line Chart
Hi
I've made line chart of Cost by quarter in Power BI as below.
I want to add trend line of this, but there is no Trend line item in Analytics section.
Would you please let me know how to add trend line in this chart?
Thank you.
me418
Use the date column instead of TEXT Year&Quarter on the X-axis like the following.Then you can change the x-axis type to continuous that allows you to add a trend line.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
9 Replies
- amitchandak
Super User
me418 , this is a qtr trend, what do mean by trend line?
Hi AmitChandak,
Yes, The line chart shows quarterly trends itself, but we need trend line which shows tendency of total quarters.
Hi @me418 .
If you want to add a trend line then you have to first change your X-Axis type to 'Continuous'.
Regards,
Sanket Bhagwat.
If this post helps, then please mark it as 'Accept as Solution' so that other members could find it quickly.
Hi Sanket Bhagwat,
Thank you for your reply.
but if I select the X-Axis type to 'Continuous', then it's forced to change 'Categorial'.
Is there any option that I have to choose?
me418
Use the date column instead of TEXT Year&Quarter on the X-axis like the following.Then you can change the x-axis type to continuous that allows you to add a trend line.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
