Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

How to Add Exponential trendlines ?

How to add exponential Trendline in the Line Chart. Please anyone help.

2 Replies

  • Anonymous , You have create you own line, You can create Exp function

    https://learn.microsoft.com/en-us/dax/exp-function-dax

     

    You also use cumulative calculation, before exp, if needed

    Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date])))

    Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    Hope all is going well.

     

    Currently, Power BI does not support adding exponential trendlines directly to visuals through Power BI Desktop, as you can in Excel.

     

    You must create your own "trendline", which can be done by creating a DAX measure or using an R script visual.

     

    At present, it is not possible to change the "algorithm" of the "automatic" trendline.

     

    You can refer to this post for more related content, I hope this is helpful to you.

    Solved: Trendlines in Power BI - Microsoft Fabric Community

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!