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

2 min. read

Updated onOctober 4, 2023

updated onOctober 4, 2023

Share this article

Improve this guide

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

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

The official Power BI forum hasplenty of threadsrelated to trend line issues:

I have a fact table with salesdatawhich 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 thedataI 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

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 inPower BI? Share with us your method in the comments section below.

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

Steps to add a trend line in Power BI#

Conclusion#

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

Steps to add a trend line in Power BI

Conclusion