Forum Discussion
Correlation in Scatter Plot Help
Hi
I have the following columns.
| Employee | X1 | X2 | Y |
| E1 | 3 | 2 | 2.2 |
| E2 | 4 | 4 | 3.1 |
| E3 | 1 | 1 | 1.4 |
| E4 | 1 | 1 | 1.6 |
| E5 | 3 | 2 | 2.4 |
| E6 | 3 | 1 | 3.8 |
I want to find two different correlations (X1,Y) and (X2,Y). Which I am able to using Power BI's quick measure.
However I want to put the Correlation Values in X-axis and another corresponding Parameter say 'Z Parameter' on Y-axis.
Scatter Plot: X-axis: Correlation with Y
Y-axis: Z Parameter
I am not able to do this, as correlations are different individual MEASURES and I need the correlation values in the below TABLE FORMAT to achieve scatter plot as shown in FIGURE 1
Ideal Table Format
| Correlation with Y | Z Parameter | |
| X1 | 0.61 | 56.44% |
| X2 | 0.53 | 57.43% |
FIGURE 1
Currently I am able to achieve this using Excel. However I would like to be able to do this on Power BI itself.
Is there a way for me to get the CORRELATION QUICK measures in a calculated column?
I appreciate all the help I can get.
1 Reply
"Is there a way for me to get measures into a calculated column? "
That is fundamentally unsupported, unfortunately.
