How to add a trend line in Power BI [STEP-BY-STEP GUIDE]

by Milan Stanojevic
Milan Stanojevic
Milan Stanojevic
Windows & Software Expert
Milan has been enthusiastic about technology ever since his childhood days, and this led him to take interest in all PC-related technologies. He's a PC enthusiast and he... read more
Affiliate Disclosure
To fix various PC problems, we recommend DriverFix:
This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:

  1. Download DriverFix (verified download file).
  2. Click Start Scan to find all problematic drivers.
  3. Click Update Drivers to get new versions and avoid system malfunctionings.
  • DriverFix has been downloaded by 0 readers this month.

Adding a trend line is one of the most useful features in Power BI. But sometimes users are encountering problems with this operation.

The official Power BI forum has plenty of threads related to trend line issues:

I have a fact table with sales data which includes a SalesPeriod value. A related SalesPeriod table contains the SalesPeriodID that ties back to the Sales table and includes a “DateOfSales” column which is a datetime. When I add a column visualization, I would like to be able to add a trend line, but do not see that option under the Formatting tab. Note, there is one row in the SalesPeriod table per month where the DateOfSales values are the 1st of each month (all sales occur in a given month.year, aggregated in the data I am provided). I have select Continuous for the X-Axis type (which is the date field) and get expected results, but do not see a Trend Line option using the latest PowerBI desktop update.

So, the OP didn’t know how to add a trend line to the chart. Fortunately, this can be solved easily in a few steps and today we will show you how.

Steps to add a trend line in Power BI

  1. Go to Visualizations and select Fields tab.power bi trend line
  2. Check Sales Date and select SalesDate. It will automatically deselect Date Hierarchy.power bi trend line sales date
  3. Now you can see in the image below that the trend line appears when you select SalesDate.power bi tren line date

We’ve written a nice piece about Power BI, do check it out.


So, there you have it: a really simple solution for a very important issue. The trend line appears with just a little twitch in the options.

How do you add a trend line in Power BI? Share with us your method in the comments section below.


Still having issues? Fix them with this tool:


If the advices above haven't solved your issue, your PC may experience deeper Windows problems. We recommend downloading this PC Repair tool (rated Great on to easily address them. After installation, simply click the Start Scan button and then press on Repair All.

This article covers:Topics: