The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
How to add exponential Trendline in the Line Chart. Please anyone help.
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!
@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])))