Open Side Menu
Skip to contentBrand Logo
Forums
Inspiration
Ideas
Communities
Blogs
Learning
Support
RegisterSign In
  1. Microsoft Fabric Community
  2. Power BI forums
  3. Galleries
  4. R Script Showcase
Sharon's avatar
Sharon
Microsoft Employee
10 years ago

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...
Correlation Plot Showcase.pbix470 KB
ScriptInstallPackagesWithWorkaroundsCorrplot.R1 KB
Advanced Analytics Visualizations
boefraty's avatar
boefraty
Microsoft Employee
9 years ago

Hi  ironryan77, 

Can you please share with me the PBIX, so I'd be able to reproduce this error?  

ironryan77's avatar
ironryan77
Kudo Commander
9 years ago
  1. How does corrplot calculate correlation matrices?
  2. Is this based on Pearson’s correlation coefficient formula? When I try plugging in my values to this formula, they do not match.
  3. Does corrplot remove duplicate rows?
  4. Does it handle aggregated columns?
  • Mike_Carlo's avatar
    Mike_Carlo
    Most Valuable Professional
    9 years ago

    Here is the documentation on the corrplot function that was used. 

     

    https://cran.r-project.org/web/packages/corrplot/corrplot.pdf

    • JaouadZrhibi's avatar
      JaouadZrhibi
      Helper I
      8 years ago

      Hi,

       

      After reading your nice posts, I need some help.

       

      (Sorry, I m beginner on Power BI).

       

      https://app.powerbi.com/view?r=eyJrIjoiNGNjYWEyMDItMmVhYS00OTVmLTgxM2ItYjFmMjYyODVmMDU5IiwidCI6IjBiOWI3NWE3LTk0MTQtNDg0Ny05NjBkLWRiN2YxNzgyMjk2ZSIsImMiOjl9

       

       

      I would like to build graphs or indicators in order to see correlations between countries in import trade according 2 variables : weights in TON and volumes in USD.

       

       

      I added this code but it doesn't work : 

       

      require("corrplot")
      library(corrplot)

      M <- cor(dataset)

      corrplot(M, method = "circle", tl.cex=0.6, tl.srt = 45, tl.col = "black", type= "upper", order="hclust")

       

       

       

      If you have any suggestions, please advise.

       

      Thank you in advance for your time and help,

       

      Jaouad

      Example_Mattress imports trade statistics.pbix1 MB
      • boefraty's avatar
        boefraty
        Microsoft Employee
        8 years ago

        Hi JaouadZrhibi, 

        Your code is almost perfect just di right-click on your data clumns and select  "Don't summarize" 

  • © 2026 Microsoft
  • Manage cookies
  • Privacy & cookies
  • Terms of use
  • Trademarks
Your Privacy Choices Consumer Health Privacy