cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sadechokan
New Member

Represent multiple linear regressions on one single graph

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

4 REPLIES 4
DavisBI
Solution Specialist
Solution Specialist

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
Microsoft
Microsoft

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

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

Hi Salim,

 

Look at the picture below please.

 

RegressionMulti.PNG

 

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors