How to create a native pearson correlation table in PWBI with output similar to SPSS?

[cnauber]

The idea is from the solution already presented by, e.g. @Super User (https://community.powerbi.com/t5/Desktop/matrix-visualization-correlation-plot/m-p/2041308) to incorporate the p-value and remove the color and incorporate the p-value and present the output as the example below:

The base file is available , click here: file

Description of the values that make up the cell:

Expected Output in PWBI:

[v-chenwuz-msft]

Hi @cnauber ,

Maybe you can refer this example to do that.

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[cnauber]

Hi, visually this is the idea, but the calculations are not correct yet. Let's take as an example the result of correlation and p-value between Carb x Disp. In PWBI I'm not getting the correct result. For a better understanding, follow the calculation method in Excel for this example. It only remains to fix this to complete the problem.

Updated PWBI file: file

Excel memorial calculation: file
Best Regards