Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |