I want to make a correlation plot with field parameter in power bi.
Suppose my data looks like this:
| ID | Height | Age | Weight | IQ |
| 1 | 172 | 18 | 144 | 100 |
| ... | ... | ... | ... | ... |
and perhaps another table
| ID | Salary | Number of children |
| 1 | 100,000 | 1 |
| ... | ... | ... |
I have created two parameter fields and placed them in the x and y axis of a scatter chart, that way I can see a scatter plot of any two variables, and how they are correlated with each other for example:
age vs salary, salary vs number of children, height vs weight, and so on.
This works fine but I want to be able to work out the R squared value between any two given parameters.
Basically I want the output to be a matrix that looks like this:
| | height | age | weight | iq | salary | #children |
| height | 1 | 0.8865 | ... | ... | ... | ... |
| age | 0.8865 | 1 | ... | ... | ... | ... |
| weight | ... | ... | 1 | .... | ... | ... |
| iq | ... | ... | ... | 1 | ... | ... |
| salary | ... | ... | ... | .... | 1 | ... |
| #children | ... | ... | ... | ... | ... | 1 |
Can anyone help me to do this please.
The first step I did was to put my parameter field in a matrix with the x axis and y axis having the parameter field, this should look like the above but without the values in the matrix but it doesn't display properly
