Forum Discussion
Solved
Reporting on long text strings separated by a semi-colons
Hi, I am trying to report on the results of a large survey where the users were allowed to select multiple reponses to each question. There was a separate database field created to record th...
eamonnj1982 I would suggest to split up responses column via power bi desktop query editor using semi-colon as delimiter. Then under Transform tab use Unpivot Column feature to convert collect all responses in one column against questions and then simply use Matrix visual to report on responses to each question.
ankitpatira
Community Champion
Community Championeamonnj1982 I would suggest to split up responses column via power bi desktop query editor using semi-colon as delimiter. Then under Transform tab use Unpivot Column feature to convert collect all responses in one column against questions and then simply use Matrix visual to report on responses to each question.
Thanks for the suggestion Ankit. I'll give this a go.