From what I understand you might have to format survey data in the data source. Check out the "Reshaping Data and Building Visualizations" section of the Visualizing Survey Data whitepaper for more information on how to format survey data.
You might also want to check out the Knowledge Base article Working with Survey Data, which normalizes survey data using a custom SQL connection, and may also be useful. However, the method described is specifically for questions that have one answer each and therefore the method may need to be modified.
I hope this helps!
Thank you so much!