Forum Discussion

Sbudd's avatar
Sbudd
Helper II
5 years ago
Solved

Trendline difficulty

Hi

 

I have a graph (Below) with:

Date on the x-axis (Date data type)

Yellow in Values (Whole number data type)

Blue & Green in Secondary Values (Percentage data type)

 

But I dont get the option to put in trendlines, what am I doing wrong?

Thanks in advance

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Sbudd ,

     

    The trend line option is in the Analytics pane.

     

    If you don't see it in Analytics pane, first change the X-axis - Type to "Continuous". Then you'll see it.

    Reference: How to Add a Trend Line in Power BI Chart

     

    Tips: The following visuals can use a trend line if there's time data:

    • Area chart
    • Clustered column chart
    • Line chart
    • Line and clustered column chart
    • Scatter chart

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Sbudd ,

     

    The trend line option is in the Analytics pane.

     

    If you don't see it in Analytics pane, first change the X-axis - Type to "Continuous". Then you'll see it.

    Reference: How to Add a Trend Line in Power BI Chart

     

    Tips: The following visuals can use a trend line if there's time data:

    • Area chart
    • Clustered column chart
    • Line chart
    • Line and clustered column chart
    • Scatter chart

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.