Forum Discussion

sadechokan's avatar
sadechokan
New Member
7 years ago

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 differe...
v-evelk's avatar
v-evelk
Microsoft Employee
7 years ago

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
[email protected]

sadechokan's avatar
sadechokan
New Member
7 years ago

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's avatar
    v-evelk
    Microsoft Employee
    7 years ago

    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
    [email protected]