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  

       

    • Cortana's avatar
      Cortana
      Helper IV
      3 years ago

      Is it updated yet? I am facing the same problem. Is the index parameter added yet?