Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Correlation plot: incorrect calculation

Hi,   I have a problem with the Correlation plot custom visual in Power BI, it displays the visual as it should but the numbers are all wrong. Even if I use a very simple Excel file with just 30 ob...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Fredrik,

     

    Good news. The Product Team will improve this visual in the next version. They also provide a more beautiful workaround, using a textual index column instead of a numeric index column. Please refer to the snapshot below.

    Correlation-plot-incorrect-calculation2

    Correlation-plot-incorrect-calculation3

     

     

    Best Regards,

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

The root cause is that Power BI removes the duplicates. The visual just uses a small part of the whole dataset. So the workaround is adding an index for now. I have consulted the Product Team and will update here later.

Correlation-plot-incorrect-calculation

 

 

Best Regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Ah, that makes sense - thanks a lot for your reply!

    I'll use the workaround for now  :)

     

    Best regards,

    Fredrik  

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      Hi Fredrik,

       

      Good news. The Product Team will improve this visual in the next version. They also provide a more beautiful workaround, using a textual index column instead of a numeric index column. Please refer to the snapshot below.

      Correlation-plot-incorrect-calculation2

      Correlation-plot-incorrect-calculation3

       

       

      Best Regards,

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Thanks a lot for the quick feedback! It's so nice to work with a tool that just keeps on improving all the time - good work!

         

        Regards

        Fredrik