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

Microsoft for Business » Power BI

Reading time icon 2 min. read

Calendar icon Updated on

by Milan Stanojevic 

updated on

Share this article

Readers help support Windows Report. We may get a commission if you buy through our links. Tooltip Icon

Read our disclosure page to find out how can you help Windows Report sustain the editorial team Read more

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.

Conclusion

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.

RELATED ARTICLES YOU NEED TO CHECK OUT:

Milan Stanojevic

Milan Stanojevic Shield

Windows Toubleshooting 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 spends most of his time learning about computers and technology. Before joining WindowsReport, he worked as a front-end web developer. Now, he's one of the Troubleshooting experts in our worldwide team, specializing in Windows errors & software issues.