Represent multiple linear regressions on one single graph

[sadechokan]

Hi folks,

I would like to build multiple simple linear regressions on one single graph in Power BI, using one filter to switch between the different couple of parameters (i.e. between the different linear regressions). I assume I need to add some code to make this possible.

Thanks again for your help, any useful tips would be much appreciated.

Cheers,

Salim

[DavisBI]

Hi, @sadechokan ,

There is a solution for multiple linear regression may help you a lot.

Here is the reference.

You can even use DAX to control the algorithm of linear regression.

[v-evelk]

Hi,

You can look for appropriate visual in Power BI Visuals store.

For example, I found there this visual, I am not sure that it is exactly what you need but please check it.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

[sadechokan]

Hi Evgenii,

I hope all is well. Yes, this definitely looks like the right visual. However, would you have any idea as to how I can add multiple couples of (X,Y) variables on one single graph? Indeed, from what I can see now after importing the visual, I can only input one set of variables.

Whereas as per the third screen shot from left to right which can be seen on the download page ( https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104382030?src=office), it is actually possible to represent multiple regressions on one same graph.

Thank you again very much for your help.

Cheers,

Salim

[v-evelk]

Hi Salim,

Look at the picture below please.

There is "Subgroup" bucket that is responsible for that case.

In this example it contains only 2 unique values so, it means that there will be 2 simple regression graphs and each record marked as "True" will be belong to one graph and records marked as "False" to another. If you want more graphs you just should use a new value for this field as "1", "2", "3" for instance.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com