How to Add a Trendline in Power BI

Seeing your data points plotted onto a chart is a great first step, but the real power comes from understanding the story those points are telling. One of the simplest, yet most effective tools for uncovering that story is a trendline. This article walks you through exactly what a trendline is and how you can add one to your Power BI visuals to instantly see the bigger picture in your data.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly is a Trendline and Why Bother Using One?

In simple terms, a trendline is a single straight or curved line that shows the general direction a series of data points is heading. Rather than getting lost in the daily ups and downs of your data - like the rollercoaster of daily website traffic or social media mentions - a trendline smooths everything out to reveal the underlying pattern.

Think about a chart showing your website's daily sessions for the last year. Some days are high, others are low. It looks much like a jagged mountain range. A trendline on top of that would be a straight or gently curved line that answers the real question: "Overall, is our traffic getting better or worse over time?"

Here’s why they are so useful:

• Spotting Trends at a Glance: Is revenue slowly increasing? Are customer support inquiries trending downward? A trendline makes the main direction immediately obvious.
• Identifying Patterns: It helps you see beyond the noise. You might have a huge sales spike one month and a dip the next, but the trendline can show you if the general trajectory is still positive.
• Basics of Forecasting: While not a full-blown predictive model, a trendline can give you a rough idea of where things are headed, helping you set more realistic goals and make better-informed decisions.

Adding a trendline shifts your perspective from just looking at raw data to truly understanding your business's performance over time. It transforms a descriptive chart into a far more analytical tool.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Prepping Your Data for a Trendline: Starting Right

Before you can add a trendline, you need to make sure your visualization and its source data are set up correctly. Trendlines typically analyze data over a period of time, so your data should have a few key components.

The Two Must-Have Items

For a trendline to work effectively, your chart typically needs:

1. A Time-Based Axis (Your X-axis): This is the horizontal axis where you'd plot time. It should be a column containing dates, months, quarters, or years. Power BI is smart about handling data types, so make sure your date column is recognized as a 'Date' type.
2. A Numeric Value (Your Y-axis): This is the vertical axis that measures what you're tracking. It should be a numeric field like 'Sales,' 'Revenue,' 'Traffic Count,' or 'Number of Subscribers.'

For example, imagine an Excel sheet or data table that looks like this:

'Month', 'Sales', 'Website Sessions' 'Jan-2023', '10,000', '5,500' 'Feb-2023', '12,500', '5,800' 'Mar-2023', '11,000', '6,200' ...etc.

This simple structure is perfect. You have the 'Month' (your time-based axis) and the numerical values ('Sales' or 'Website Sessions'), which gives Power BI what it needs to draw the trend.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What About Other Chart Types?

While trendlines are commonly associated with line charts, they can also work well with other chart types:

• Bar Charts/Column Charts: Useful for showing trends across discrete time periods, like months or years. Power BI will draw a line across the tops of the bars/columns to highlight the overall pattern.
• Scatter Plots: A scatter plot shows data points with two different numeric values. Trendlines here can be useful for showing correlations between two variables, such as "What's the relationship between how much a user spends on ads and the ad revenue generated from their ad campaign?"

The most important thing is that your chart has an X-axis that represents a logical progression, usually like time.

Step-by-Step: Adding a Trendline to Your Visual in Power BI

Now that you have an understanding of the why and the what, let's get to the actual steps. Adding a trendline in Power BI is surprisingly simple - if you know where to look.

Step 1: Build Your Basic Visual

First, create your base visual on the Power BI canvas. For this example, let's make a line chart that shows total sales over time.

• In the Visualizations pane on the right, select the 'Line chart' icon.
• From your Fields pane, drag your date field (e.g., 'Date') to the 'X-axis' slot.
• Drag your numeric value (e.g., 'Total Sales') to the 'Y-axis' slot.

At this point, you'll see a standard line chart showing the day-to-day ups and downs in your sales data.

Step 2: Find the Analytics Pane

This is the secret step - the one where many people get stuck. The Analytics Pane is somewhat hidden.

• With your new visual selected, look at the Visualizations pane.
• Above the fields, you'll see a few icons for Build a visual, Format your visual, and a little magnifying glass.
• Click that magnifying glass – that’s the Analytics pane.

The Analytics pane is where Power BI houses its analytical and valuable features like "average" lines, constant lines, and - you guessed it - trendlines.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Add the Trend Line

Within the Analytics pane, you'll see an option for Trend line. Expand that menu to click on the downward arrow next to it.

• You will see a button or text that says Add. Click it.
• As soon as you click Add, Power BI instantly adds a linear trendline on top of your chart.

Customizing Your Trendline for Better Insights

Power BI not only allows you to easily add a trendline, but it also gives you tools to make it more meaningful and visually effective. When you are on the trendline settings pane, you'll see several customization options.

Color and Style

• Color: Change the color from the default to make it stand out, and match your company's branding to maintain consistency in your reports.
• Style: Adjust the style from solid to dashed or dotted lines, if you prefer, depending on your needs.

Trendline Formations

You'll also find options for forecasting, which can be incredibly helpful to anticipate trends. Enable it to explore these possibilities:

• Polynomial: Ideal for data sets with peaks and valleys, allowing the trendline to accommodate curvature.
• Exponential: This type is often used for data which increases or decreases rapidly.

Final Thoughts

Adding a trendline to your Power BI visuals is a straightforward way to unlock the underlying trends within your data. While trendlines provide useful insights for many teams, sometimes you have to dig deeper to get the initial insights faster.

For complete control over your data reporting and insights, consider using platforms like Graphed. With its powerful integration capabilities, you can sync data across sources, enhancing your analytic reports with precision and depth for business insights you can rely on.