How to show a correlation matrix from the results in a single table?

[dancarr22]

Hello,

Is there a way to create a correlation matrix from the results in a single table?  Please see dataset below.

Basically, we have a list of currencies for a given date -- and what to compare all currencies against each other.

Thanks,

Dan

[v-huizhn-msft · Accepted solution]

Hi @dancarr22,

There is no such a direct visual in Power BI. I personally suggest you create a correlation matrix using R statement. First, you need to install R, then enable R visual following by the steps in this article.

Actually, I am confused with which fields should used to create the correlation. For example, we use the following sample data in R.

# Load data
data("mtcars")
my_data <- mtcars[, c(1,3,4,5,6,7)]
# print the first 6 rows
head(my_data, 6)

We will get the correlation matrix using the code. More details, please see this blog.

res <- cor(my_data)

You can also use the custom visual Correlation plot, you can download the sample table, and create your own according to the sample.

Best Regards,
Angelia