cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
eamonnj1982 Frequent Visitor
Frequent Visitor

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 the responses to each question and if the user selected multiple responses then they are separated by a semi-colon in the field. 

 

For example (I have all the responses for Questions 1 stored like this):

Question1: Response 1;Response4;Response9

Question1: Response 2;Response8

Question1: Response 3;Response5;Response6

Question1: Response 4

 

Could anyone offer the best way to be able to report on each response?

 

Many thanks


1 ACCEPTED SOLUTION

Accepted Solutions
ankitpatira Super Contributor
Super Contributor

Re: Reporting on long text strings separated by a semi-colons

@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.

2 REPLIES 2
ankitpatira Super Contributor
Super Contributor

Re: Reporting on long text strings separated by a semi-colons

@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.

eamonnj1982 Frequent Visitor
Frequent Visitor

Re: Reporting on long text strings separated by a semi-colons

Thanks for the suggestion Ankit.  I'll give this a go. 

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 21 members 803 guests
Please welcome our newest community members: