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.
1 ACCEPTED SOLUTION
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.
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.
