Trendline difficulty

[Sbudd]

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

[v-stephen-msft · Accepted solution]

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.