Correlation indicator or Clustering as K-means ?

[JaouadZrhibi]

Hi,

I need to configure correlation or clustering as K-means on my dashboard but it doesn't "work".

Target : just see correlation between countries according one variable : tons or USD (not both).

For example, we compare only weight on Chinese imports VS US imports, China vs France, China vs Canada…

Then, US imports vs France imports, US vs Germany...with all possible combinations.

Results show us the most correlated countries in term of imports in a period of time (2001 till 2017)

https://drive.google.com/open?id=1Sjc5jF4L9EYOWwPbf-srLkKGjO9zaYln

Thank you for your kind help,

Jaouad

[v-yuezhe-msft]

@JaouadZrhibi,

How about you use the clustering custom visual?

The other way I can find is to write R code to cluster data using k-mean algorithm.
https://community.powerbi.com/t5/R-Script-Showcase/Clustering-using-k-mean-in-power-query-elbow-char...


Regards,
Lydia