Forum Discussion
Non Linear Regression in Power BI
Hi,
I am struggling to find an article on doing non linear regression in Power BI. More specifically, I am dealing with power regression. So far, I know that Power BI is able to allow for a basic trend line on a scatter plot, but I am looking for the ability to create a non linear regression line that goes through my data points, and changes dynamically based on any filters applied. I am looking to do this with no external coding platforms such as R or Python.
Is this possible?
Notes:
1) I already have created a scatter plot, and I am just looking to create a power regression line that goes through them based on the formula y = a(b^x)
y = dependent variable
x = independent variable
a = slope
b = constant
Yes there is, you can do some slight modifications using LINEST function. I just need to dig up the article. I still think you might struggle plotting a line over a scatter chart.
Otherwise Deneb custom visual is an excellent and easy way to do non-linear regression:
2023 Week 07 | Power BI: Non-linear Regression – Workout Wednesday (workout-wednesday.com)
Solution file : Workout Wednesday 2023 Week 7 | Non-linear Regress... - Microsoft Fabric Community
Regression types here: Regression | Vega-Lite
1 Reply
Yes there is, you can do some slight modifications using LINEST function. I just need to dig up the article. I still think you might struggle plotting a line over a scatter chart.
Otherwise Deneb custom visual is an excellent and easy way to do non-linear regression:
2023 Week 07 | Power BI: Non-linear Regression – Workout Wednesday (workout-wednesday.com)
Solution file : Workout Wednesday 2023 Week 7 | Non-linear Regress... - Microsoft Fabric Community
Regression types here: Regression | Vega-Lite