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

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'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.