Forum Discussion

Ruedi007's avatar
Ruedi007
Frequent Visitor
6 years ago
Solved

Multidynamic (x- and y-Axis) Regression

Hello! I try to accomplish the following thing. I have a dataset with variables v1,v2,....,vn I try to greate a regession plot where I have two filters one for the x and one for the y axis w...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Ruedi007 

    I build a table to have a test.

    After transforming, rename Table as X axis. You need to duplicate the X axis table and rename the new one as Y axis.

    Build relationship between Index column in two tables.

    Build a Scatter chart or line chart to see the result.

    You can download the pbix file from this link:  Multidynamic (x- and y-Axis) Regression

     

    Best Regards,

    Rico Zhou

     

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

MFelix's avatar
MFelix
Super User
6 years ago

Hi Ruedi007 ,

 

What you need to do in this case (and be aware that there is not much information to get on by) is to create two disconnected tables with the V1, V2,... ,VN.

 

Then you mus create your values to be filtered out on the selection of the slicer:

 

Measure =
VAR X_Value =
    SELECTEDVALUE ( TableX[Column] )
VAR Y_Value =
    SELECTEDVALUE ( TableY[Column] )
RETURN
    DIVIDE (
        CALCULATE ( SUM ( Table[Column] ), FILTER ( Table, Table[Column] = X_Value ) ),
        CALCULATE ( SUM ( Table[Column] ), FILTER ( Table, Table[Column] = Y_Value ) )
    )

Be aware that this measure does not make the regression, and that this is only a very simplified way to get information the values need to be adjusted.

 

Regarding a regreession you can see this post

https://community.powerbi.com/t5/Desktop/Simple-Linear-Regression-with-DAX/m-p/9272#M1736

 

Also please see this post regarding How to Get Your Question Answered Quickly (courtesy of @Greg_Deckler) and How to provide sample data in the Power BI Forum (courtesy of @ImkeF).