How to visualise multiple measures in one chart?

[thanhluong]

Hi all,

I have a data set about NPS (dependent variable) and drivers (independent variables). I want to create a visualisation to show the average score of driver (y axis) and driver importance (x-axis) which is correlation score of each driver and NPS. These are steps I do in excel:

- Transform driver score to new scale (from 5-scale to 2 scale) with 4, 5 values assigned as 1, others are 0. The new transformated data would be used to calculate driver score. e.g Average score of checkout is 89% means 89% customer agree with checkout

- Then I calculate the correlation score of drivers from 5-scale (skip blanks)

I did it from Excel but want to make another in Power BI

Raw data

Excel

	Correlation with NPS	Driver Score (average)
Checkout	0.60	89%
Navigation	0.47	74%
Price	0.50	85%
Product Availability	0.54	85%
Staff Helpfulness	0.67	87%
Team Knowledge	0.60	72%

Power BI

I created measures for correlations (1), and transformed drivers to calculate average (2), but not able to combine them into a table as in excel to present data

Is there anyway to present the outputs?

Thank you!

Thanh

[thanhluong]

Thank you for your reply! I solved the problem using R, it's much easier to manipulate data.

[amitchandak · Accepted solution]

@thanhluong , one of the options is to use a matrix , with measures as values, Navigation as column(based on what I got. and Use the Switch values to rows option.

https://youtu.be/cN8AO3_vmlY?t=11650

For a more complex display consider the calculation group

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0