scatter chart with several survey questions 03-17-2017 03:55 AM

[gorli]

Hello,

I am trying to do a weight/performance analysis on several questions from a survey. This is an example of the data input (there is also another columns saying "Competitor company):

I would like to get a matrix with Weight on one axis and Performance on the other. I did unpivot the questions under Weight and then the questions under Performance and the chosed Weight under the Y-axis, average and Performance under the X-axis, average. I used the Attributes under Details and Competitor company under Legend.

The weight in the scatter chart is ok with different spots in the chart, but all questions is under the same (overall average) on Performance.  What am I doing wrong here? Grateful for assistance.

	Weight (1-5)			Performance (1-5)
Company	price	Quick deliveries	Service	Price	Quick deliveries	Service
One	4	2	4	1	5	4
Two	5	3	4	2	4	4
Three	5	3	4	3	3	5
Four	4	4	4	2	5	5

eyJrIjoiZWE3N2U0OTQtNTdlOC00NjA3LWI3YTgtMjNmMTdjYjQ4ZWNlIiwidCI6ImMxZDM5ZTIyLTY5ZjctNDk3MS1hNDQ2LTdlNmE4ZmVjOTIwZiIsImMiOjh9

[ScottFerguson]

Let me know if this works...

https://app.powerbi.com/view?r=eyJrIjoiMTQ4MDI3OGQtMjNhNS00M2ZjLWI5M2QtZTM0NDIwMDJlNDk4IiwidCI6Ijg3M...

Cheers,

SF

In God we trust... all others must bring data.

[gorli]

Hello Scott, thanks you think "out of the box". I really like the secon page. Can you tell me how you set this up? (/Details, legend, x axis, y axis)? Really would appreciate it. Best rgrds Göran

[gorli]

Both pages, please..

[gorli]

I did another setup.

https://app.powerbi.com/view?r=eyJrIjoiMjljNDdkOGEtZWViYi00ZDYzLWJlZGItZmVmMzRiYzE3YmVhIiwidCI6ImMxZ...

But of the performance questions, unpivoted columns, I only get an average of all the performance quesions, not the individual questions????

[ScottFerguson]

Here you go!

Fact Table - one column for each data elementDimension Table - Company sorted by "Order" columnScattergraph - with filtersScattergraph - with Play Axis ("Measure" not shown is in the Play Axis field)

Best,

Scott

[gorli]

Thanks Scott,

but is your data already aggregated in Excel? My data is raw, from a survey. I plan to use this model woth several houndred respondents, who answer on weight (once) and on performance for several different competotive companies. I also need to filter the answers on several different background questions.

Any idea?

Best rgrds

Göran

[ScottFerguson]

Göran,

I did restructure the data in excel based on a previous sample table you provided to create the scatter graphs I think you were working towards.

The following link is a thread discussing how to manage survey responses for use in Power BI for your reference:

     http://community.powerbi.com/t5/Desktop/Best-way-to-structure-Excel-survey-data-for-leveraging-in-Po...

The use of filters in Power BI should allow you to reduce the data to the set you need, or you can manage it through data query, or even from the excel source file to filter down to the final table you need for reporting.

Good luck!

Scott