Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Pivot or?

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 IDQuestion IDResponse
112(text)
113(text)
114(text)
212(text)
213(text)
312(text)

 

But I would like to visulize the responses like this: 

Response IDQuestion 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

 

Tips and Tricks
  • vicky_'s avatar
    vicky_
    2 years ago

    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: 

     

1 Reply

  • vicky_'s avatar
    vicky_
    Super User
    2 years ago

    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: