@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.
Madison Giammaria Proud to be a Super User 😄 LinkedIn
Do you frequently use Deneb to provide insights to your stakeholders? Have you considered sponsoring this free and open source custom visual? More info here!
