Create an exponential trend line for Price/Demand

[armonz]

I need to get an exponential trendline across a chart with Price as the y-axis and Quantity as the x-axis. I tried using a trendline on a scatter chart but I realized an exponential line is not available in Analytics, but I wonder if anyone has created a DAX formula that could help me program the trendline I need. This is a sample of data and an example of what I would need to achieve in PowerBI:

What I would be seeing is when the price gets higher the demand is low, but as we get a lower price, the demand starts increasing. 

I have seen in other posts that using linest could help me, but I have no experience using that function. Any help would be appreciated. 

[v-kaiyue-msft]

Hi @armonz ,

Thank you @amitchandak  for your replies and allow me to provide another insight:

Exponential trendlines in Power BI are a valuable tool for visualising data that exhibits exponential growth or decay. To add an exponential trendline in Power BI, simply perform the following steps:

Create a line chart in Power BI.
Add a trend line to the line chart.
Customize the trend line by adjusting the line type, colour and thickness.

For more details refer to the link: Adding Trend Lines & Forecasts in Power BI - GeeksforGeeks.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[amitchandak · Accepted solution]

@armonz , refer this

Exponential Analysis in Power BI

https://www.youtube.com/watch?v=cyQ33XgJzwQ

[armonz]

Thanks, but this video is using a running total that stacks previous results across time, but I don't need to stack my demand over time. The curve I need would be showing how the demand increases as the price gets lower.