Forum Discussion

cnauber's avatar
cnauber
Frequent Visitor
4 years ago

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

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:

Tutorial Requests

2 Replies

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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's avatar
      cnauber
      Frequent Visitor
      4 years ago

      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