Forum Discussion

soogiang's avatar
soogiang
Regular Visitor
3 years ago

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...
Need Help
soogiang's avatar
soogiang
Regular Visitor
3 years ago

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's avatar
amitchandak
Super User
3 years ago

soogiang , You can try measures like

 

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

 

or

 

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

  • soogiang's avatar
    soogiang
    Regular Visitor
    3 years ago

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