A trend line is a type of line that summarizes the trend of a dataset.
The following step-by-step example shows how to create the following line chart with a trend line in Power BI:
Let’s jump in!
Step 1: Load the Dataset
First, we will load the following dataset into Power BI that contains information about the total sales made during 15 consecutive years by some company:
Step 2: Insert the Line Chart
Next, click the Report View icon on the left hand side of the screen:
Then, on the right side of the screen under Visualizations, click the Line chart icon:
An empty line chart will be inserted:
Step 3: Populate the Chart
Next, drag the Year variable under the X-axis label, then drag the Sales variable under the Y-axis label:
This will produce the following line chart:
The x-axis displays the year and the y-axis displays the sales.
Step 4: Add a Trend Line
To add a trend line to summarize the sales over time, click the magnifying glass icon under the Visualizations tab, then toggle the Trend line to On:
The following trend line will be added to the line chart that summarizes the trend of sales over time:
Feel free to modify the color, transparency, and line style of the trend line to make it look however you would like.
The following tutorials explain how to perform other common tasks in Power BI: