Forum Discussion
SurveyMonkey to Power BI Data Transformation
Good Day I am relevently new to PowerBI and i have recently connected my SurveyMonkey results to Power BI. I used a Matrix scale survey and now all my 130 questions that I created is in a sin...
v-kelly-msft
Community Support
Community SupportHi Nodmaster13 ,
You could use "Unpivot"columns to realize it,check a similar thread below:
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
We have SurveyMonkey enterprise, and regularly use these surveys for ongoing and special purpose customer feedback for multiple customer segments. I am also regularly using unpivot for the "choose all that apply" data. For some data, this is the only way I transform it. For other data, such as race/ethnicity, I use multiple functions and groupings in order to visualize this data from multiple perspectives.
Correction: the only way I transform it