Column Chart/Trend Line

[Anonymous]

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.

I'm pretty new to this, so must be missing something obvious, but cannot figure this one out!

[avisingh · Accepted solution]

I recorded a quick video (see below) to explain my answer.
I was able to add a trend line using a Sample Data Set I created based on your question.
Check out the video below.
Download my solution PBIX file attached

⚡Power On!⚡
-Avi Singh

YouTube, Facebook, Twitter, Web

[Anonymous]

@avisingh  hey there stranger.. so I have been searching EVERYWHERE on how to do a Trend lines in PBI... I know this video is old,  they must have removed this feature because everyone shows the same thing you do all over the web (old nothing updated) but this option in no longer under (Visualizations) Analytics for Bar or Line charts... I have been struggling for a week to find help from someone... My management LIVES ON TREND LINES in Excel.. I don't want to go backwards with using Excel its too much work... can you help me?  Power On!!

[Anonymous]

Avi,

Wow, thanks for that very helpful video. EVERYTHING I read on trend lines indicated that it was under the Formatting tab, not Analytics. Watching your video pointed in to exactly the right place and my visualization is not working. Many thanks for the help, now if only MS could fix the documentation!

[Anonymous]

This is very cool, but...I have a Line and Clustered Column chart, with two clustered columns and one line.  I want individual trendlines for the columns, but no trendline for the line.  When I add a new trendline, I get two by default--one that combines the column data, another for the line.  When I turn off "Combine Series" the column trendlines separate, but the line trendline remains.  Any way to control the trendlines independently?