cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Microsoft
Microsoft

Re: Represent multiple linear regressions on one single graph

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

Highlighted
New Member

Re: Represent multiple linear regressions on one single graph

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

Re: Represent multiple linear regressions on one single graph

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

Highlighted
Advocate II
Advocate II

Re: Represent multiple linear regressions on one single graph

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.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Kudoed Authors