Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
omegaadmin
Regular Visitor

Correlation in Scatter Plot Help

Hi

I have the following columns.

 

EmployeeX1X2Y
E1322.2
E2443.1
E3111.4
E4111.6
E5322.4
E6313.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 YZ Parameter
X10.6156.44%
X20.5357.43%

 

FIGURE 1FIGURE 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 1
lbendlin
Super User
Super User

"Is there a way for me to get measures into a calculated column? "

 

That is fundamentally unsupported, unfortunately.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.