@JimmyCruyp had asked about creating a correlation matrix and I realized I had never made one. After a bit of stumbling in Deneb, I also quickly realized that I didn't know how to quite perform the calculations. During my research I learned that often these matrices are generated with ease in r or Python.
I found a really great guide by Parker Stevens using only Power Query, DAX, and the native matrix visual in Power BI. His version used colored squares as the visual indicators for positive/negative correlations.
The original question that got me interested had the correlation coefficients encoded as colored and sized circles. There were also text marks to show the correlation coefficient values themselves. In an effort to try to keep everything native, I generated the marks as SVGs via DAX. Below is the result.
I highly suggest checking out the guide and his example file.
Parker's guide: https://lnkd.in/eEaiafNS
Original question: https://lnkd.in/efy2G9pE
Downloadable .pbix: https://lnkd.in/eAeSvgw6
eyJrIjoiMTZkMmQ1NDctMzA2Mi00MGNhLTk1MzUtMzQyYjQxNDBjMjU3IiwidCI6ImRmODY3OWNkLWE4MGUtNDVkOC05OWFjLWM4M2VkN2ZmOTVhMCJ9
Madison GiammariaSuper User In Training
😄LinkedIn
