Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Survey Scoring Table

Hi all,   I have a survey from survey monkey that I have loaded into Power Bi. Its a column (the question) with the response below it as the value.     In addition to this, I created a tab...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks snokku. I would do that but how do I not pivot the ID portion of the row. The respondant's ID is on the same row as the responses. Is there a way to pivot just the responses while keeping ID as a column?\

 

Thanks in advance.

snokku's avatar
snokku
Helper I
6 years ago

Hi Anonymous,

Just select the columns aside from ID column when you pivot/unpivot.

 

Thanks,

snokku