cancel
Showing results for
Did you mean:
Highlighted
Member

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft

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

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

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

Microsoft

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

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

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

Announcements

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!