Adding Trend line with DAX?

[soogiang]

Hi,

I am trying to add a Trend Line to a Line and clustered column chart as below.

Is it possible to create a trend line using DAX  like the one in Excel?

"avg of ph average Roll" data need to be used for the trend line.

Any thoughts / help greatly appreciated!

Here is my sample data

Data_pbix 

[amitchandak]

@soogiang , You can use the analytics pane Constant line of Avg Line

I have an example for scatter here

Power BI Customer to Retain, Scatter Quadrant -Segment in 4 quadrants based on Margin % and Discount, Use Constant Line- https://youtu.be/0k_C_E7YOQY

[soogiang]

I am seeing Error bars option only. I dont think the analytics pane is available in my line and cluster column chart. any idea?

[amitchandak]

@soogiang , You can try measures like

Measure = CALCULATE(AVERAGE('Table'[Average of Time]), ALLSELECTED())

or

Measure = CALCULATE(AVERAGE('Table'[Ph Average Roll]), ALLSELECTED())

[soogiang]

your measure added a constant line, but it is not a correct trend line.