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,

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?