cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Column Chart/Trend Line

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Column Chart/Trend Line

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

View solution in original post

4 REPLIES 4
Highlighted

Re: Column Chart/Trend Line

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

View solution in original post

Highlighted
Helper I
Helper I

Re: Column Chart/Trend Line

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!

Highlighted
Frequent Visitor

Re: Column Chart/Trend Line

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?

Highlighted
Frequent Visitor

Re: Column Chart/Trend Line

@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!!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors