Forum Discussion
Creating Correlation
Thank you for your answers!I find the solution.I created the pearson correlation using DAX.Then i applied the numbers as labels in my Graph.It would be great if DAX had Correl(Excel's function) in DAX.
Do any of these do what you need:
- corrplot per https://community.powerbi.com/t5/R-Script-Showcase/Correlation-Plot/td-p/58462 and https://community.powerbi.com/t5/Desktop/Custom-correlations-or-visuals/td-p/84392
- chart.Correlation per http://www.sthda.com/english/wiki/correlation-matrix-a-quick-start-guide-to-analyze-format-and-visualize-a-correlation-matrix-using-r-software
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-r-visuals/ has a good introduction to R in Power BI and also describes the current Known Limitations.
Thank you for your answer.I have created the plot in PowerBI,my main concern is to see the correlation number for every country that i have in my sample.I give you a screenshot!If there is a way to create a plot for every country.
Thank you
I'm not exactly sure what dataset you're working from or what end result you need and I'm no statistician, but the following may help "group" within corrplot: http://stackoverflow.com/questions/33615112/run-corrplot-to-a-data-frame-by-group
There's also some discussion on techniques here: http://stackoverflow.com/questions/5453336/plot-correlation-matrix-into-a-graph
Good luck!
Hi Elpida1803,
Please share us some sample data and the expected result, so that we can make further analysis.
Regards,
Charlie Liao
