Trend Line Not Working in Line Chart

[m_mahmud]

I wanted to show a trend line by month in a line chart. I am using a date table in the Data model. When I limit the date only for two months, it shows the trend by date, not month. When I limit it to more than two months, it shows by month.

Note: I need to show both the line and the trend line, which requires a continuous date field to work.

 

[Ritaf1983 · Accepted solution]

Hi @m_mahmud 

The trend line is an automatic feature in Power BI that only works when certain conditions are met:

1. The X-axis must use a continuous field (either date or numeric type).

2. There must be enough data points for the engine to calculate a meaningful trend.

If you're using "Month" as your X-axis, it's likely a categorical field, not continuous — so the trend line won’t appear.
Also, when you limit the time range, the chart may revert to showing daily data (which is continuous), but either too few or too many points can prevent the trend line from rendering.
This feature cannot be manually forced — Power BI enables it only when these conditions are satisfied.

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