Pivot or?

[emilyhch]

Hi there! 

I have a problem that I hope to get your insigh and help! I feel like it is related pivot or some sort but lacking knowledge and experience in this so cannot figure it out. I tried Matrix visual but that only gave me the counts but I need it to show the actual text/response in that cell. 

I have a table (data is linked through a SQL database) containing response ID, question ID and corresponding responses similar to below:

Response ID	Question ID	Response
1	12	(text)
1	13	(text)
1	14	(text)
2	12	(text)
2	13	(text)
3	12	(text)

But I would like to visulize the responses like this: 

Response ID	Question 12 Response	Question 13 Response	Question 14 Response
1	(text)	(text)	(text)
2	(text)	(text)	(text)
3	(text)	(text)	(text)

How should I do it? 

Thank you very much! 

Emily

[vicky_ · Accepted solution]

if each combo of question and response only has one answer (or if you only want to show the first / last answer), then you should be able to use a matrix visual:

If there's more than one text and you need to show all, then you can write a measure:

i.e my sample data:

and measure: 

All Responses = CONCATENATEX(VALUES('Table'[Response]), 'Table'[Response], ", ")

and the output: