Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Setting an intercept for a trend line

Hello,

 

I am trying to create trend lines in a scatter chart. Unfortunately these trends are not helpful unless the y-intercept can be set at y=0. Is there any way to create trend lines with intercept conditions?

 

Thank you

Custom Visuals

3 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Anonymous ,

     

    You can set the start position of Y-axis in the format pane like below:

     

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      v-yuta-msft ,

       

      Thank you for your reply but this is not what I meant.

       

      I would like to set an intercept on the trend line analytics such that each line crosses the origin (0,0) point. Currently, trend lines are only showing best fit linear regressions that don't take intercepts into account. I have attached a screenshot to show what I mean:

       

       

      Thank you

      • v-yuta-msft's avatar
        v-yuta-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Anonymous ,

         

        I would suggest you use Python/R visual instead in this senario.

         

        Community Support Team _ Jimmy Tao

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.