Help creating an AutoML (Machine Learning Model) on Power BI Apps

[HamidBee]

Hi All,

I'm working on the table below:

I'm trying to predict the values for the year 2022. However I'm not sure if the table should have been unpivotted first.

Also, when I apply the machine learning model I am confronted with the following options:

 

I am really not sure which options to select. I could be setting this model up the wrong way I am not entirely sure. Any help would be greatly appreciated.

Thank you,

 

[v-henryk-mstf]

Hi @HamidBee ,

Based on your description, I think you can refer to the tutorial given in the official documentation below. Hope it will help you.

Tutorial: Build a Machine Learning model in Power BI

If the problem is still not resolved, please point it out. Looking forward to your feedback.

Best Regards,
Henry

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

[HamidBee]

Hi @v-henryk-mstf,

I honsetly used this tutorial when I first began. Unfortunately this tutorial wouldn't be entirely the same for me as I would be using a regression model. In this tutorial they show one how to use a binary model. So the way the data is set up wouldn't be the same. I've yet to see an example or explanation where someone is using a regression model here. Could you please provide a step by step guide on how I could use a regression model via AutoML?

Thank you

[v-henryk-mstf · Accepted solution]

Hi @HamidBee ,

Sorry for misunderstanding your point. For understanding and learning regression models in machine learning, you can refer to the following blogs and documents that I hope will help you.

Building a Regression Model with zero code in Powe... - Microsoft Power BI Community

How to do Linear Regression in Power BI (iterationinsights.com)

Best Regards,
Henry

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

[amitchandak]

@HamidBee , I think you should unpivot first in power query

https://radacad.com/pivot-and-unpivot-with-power-bi

[HamidBee]

Okay, once I unpivot the data. What do I select for the outcome column and data to study fields?