cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rahulmathur7 Regular Visitor
Regular Visitor

Correlation between multiple columns

Hi Guys,

So i have a data set of feedback from the customers ,it has different questions as different columns.

I need to find correlation between one question to all the other questions.I have tried R visual but we do not have pro license hence the visual is not visible.

 

Please guys i have this as an urgent requirement .Please help me out.

2 ACCEPTED SOLUTIONS

Accepted Solutions
sturlaws New Contributor
New Contributor

Re: Correlation between multiple columns

rahulmathur7 Regular Visitor
Regular Visitor

Re: Correlation between multiple columns

Hey @sturlaws  Thanks for your help.
Now i am stuck in the visualisation part of it , i have 16 measures for different correlation with 16 different questions.
I just wanna show a simple bar chart  but i guess its not possible to make measure as X-Axis name.

View solution in original post

4 REPLIES 4
sturlaws New Contributor
New Contributor

Re: Correlation between multiple columns

rahulmathur7 Regular Visitor
Regular Visitor

Re: Correlation between multiple columns

Hey @sturlaws  Thanks for your help.
Now i am stuck in the visualisation part of it , i have 16 measures for different correlation with 16 different questions.
I just wanna show a simple bar chart  but i guess its not possible to make measure as X-Axis name.

View solution in original post

sturlaws New Contributor
New Contributor

Re: Correlation between multiple columns

Not possible to put measures on x-axis directly, true, but there is a workaround.

Create a stand alone table, that is a table without any relationships. Say your 16 measures are named measure1, measure2,...,measure16.

 

The stand alone table, let's call it tabMeasures, should have one column, let's call the column Measures. The values in this column should be text strings. For simplicity you can use the same names as your 16 measures, but it is not strictly necessary:

 

The values on the rows could/should corresponds to your measures, in  your case you should have 16 rows. Add a measure to this table like this

xAxisMeasure =
SWITCH (
    TRUE ();
    SELECTEDVALUE ( Table[measureName] ) = "measure1"; [measure1];
    SELECTEDVALUE ( Table[measureName] ) = "measure2"; [measure2];
.
.
.
SELECTEDVALUE ( Table[measureName] ) = "measure16"; [measure16]; BLANK () )

Now add the column of the new table to the x-axis, and add this measure as the measure

 

rahulmathur7 Regular Visitor
Regular Visitor

Re: Correlation between multiple columns

@sturlaws You are a genius man. Thank You so much.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,608)