Sharon
10 years agoMicrosoft Employee
Correlation Plot
Description
Correlation plots can be used to quickly find insights, showing what otherwise would require lots of iterative slicing and dicing of your data.
Download this sample to see how...
ironryan77
9 years agoKudo Commander
I love what you did here with this visual and it works perfectly in my PowerBI Desktop. However, when I try to view this from Power BI intranet, I get this error. I have tried to correct this by modifying the function and corrplot lines of code, with no success:
#verify if the column is numeric and non-constant
correctColumn <- function(someColumn) { !is.null(someColumn) && is.numeric(someColumn) && length(unique(someColumn)) > 1 }corrplot(M, method=method, order=order, type=type, addrect=addrect, #na.label = "?",
na.rm=TRUE,
mar = defMar, tl.col = tl.col, tl.cex=tl.cex, tl.srt=60, cl.ratio=0.2, cl.align="r",
number.digits=number.digits, number.cex=number.cex, addCoef.col=addCoef.col)How can I fix this?
- boefraty9 years agoMicrosoft Employee
Hi ironryan77,
Can you please share with me the PBIX, so I'd be able to reproduce this error?
- ironryan779 years agoKudo Commander
Thanks, but I think I got this working now!
- ironryan779 years agoKudo Commander
- How does corrplot calculate correlation matrices?
- Is this based on Pearson’s correlation coefficient formula? When I try plugging in my values to this formula, they do not match.
- Does corrplot remove duplicate rows?
- Does it handle aggregated columns?
- Mike_Carlo9 years agoMost Valuable Professional
Here is the documentation on the corrplot function that was used.
https://cran.r-project.org/web/packages/corrplot/corrplot.pdf