Forum Discussion

me418's avatar
me418
Regular Visitor
5 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.

 

me418's avatar
me418
Regular Visitor
5 years ago

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Can you please check the data type of your quarter column?

    If it is text, then you will need to convert it into a numeric type as trend line cannot work for text data type.

     

    Regards,

    Sanket Bhagwat