Forum Discussion
Survey responses represented as value?
Heya,
If i understand correctly this is what you want right? If so, please tell me and ill share how i did it :) if not, please explain a bit more!edit:
I did some more work to help you out and get started :) Just created some basic charts and filters so you can get familiar with how things work and how to work with your data.
But, your data is formatted bad for working with PBI (hence why you didnt get it to work).
Go to Edit Queries > select Widgets Wodgets etc > go to transform and press Unpivot Columns.
Result should be this:
Name Attribute Value Bob Widgets 5 Bob Wodgets 1 Bob Gadgets 1 Bob Bobits 2 Sally Widgets 2 Sally Wodgets 5 Sally Gadgets 5 Sally Bobits 1 Jim Widgets 1 Jim Wodgets 4 Jim Gadgets 1 Jim Bobits 2 John Widgets 3 John Wodgets 3 John Gadgets 1 John Bobits 5 you can ofcourse change attribute and value to whatever you like.
i added my PBI file here:
https://1drv.ms/u/s!AgnVgd15_ye0hB2B5PWeqoXJX9dz
Feel free to ask any other questions.
Heya,
If i understand correctly this is what you want right? If so, please tell me and ill share how i did it :) if not, please explain a bit more!
edit:
I did some more work to help you out and get started :) Just created some basic charts and filters so you can get familiar with how things work and how to work with your data.
But, your data is formatted bad for working with PBI (hence why you didnt get it to work).
Go to Edit Queries > select Widgets Wodgets etc > go to transform and press Unpivot Columns.
Result should be this:
| Name | Attribute | Value |
| Bob | Widgets | 5 |
| Bob | Wodgets | 1 |
| Bob | Gadgets | 1 |
| Bob | Bobits | 2 |
| Sally | Widgets | 2 |
| Sally | Wodgets | 5 |
| Sally | Gadgets | 5 |
| Sally | Bobits | 1 |
| Jim | Widgets | 1 |
| Jim | Wodgets | 4 |
| Jim | Gadgets | 1 |
| Jim | Bobits | 2 |
| John | Widgets | 3 |
| John | Wodgets | 3 |
| John | Gadgets | 1 |
| John | Bobits | 5 |
you can ofcourse change attribute and value to whatever you like.
i added my PBI file here:
https://1drv.ms/u/s!AgnVgd15_ye0hB2B5PWeqoXJX9dz
Feel free to ask any other questions.
YES this makes total sense! I had to delete some unused collumns (email address, merged first name/last name in order to make 1 collumn simply titled "name") in order to make it work, but this simplified and organized my data a great deal! Thank you so much, you really saved the day!!