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 be used for the trend line.

 

Any thoughts / help greatly appreciated!

 

 

 

 

Here is my sample data

 

Data_pbix 

Need Help

4 Replies

  • 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())