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.
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
Solved! Go to 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
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
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 |
---|---|
86 | |
84 | |
66 | |
62 | |
60 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |