Forum Discussion
Adding Trend line with DAX?
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...
amitchandak
Super User
Super Usersoogiang , You can try measures like
Measure = CALCULATE(AVERAGE('Table'[Average of Time]), ALLSELECTED())
or
Measure = CALCULATE(AVERAGE('Table'[Ph Average Roll]), ALLSELECTED())
your measure added a constant line, but it is not a correct trend line.