Forum Discussion
Using Microsoft Form Data
Thank you, Anonymous. It's quite clear now.
We can split the [Value] in the Query Editor. Then we can create a Matrix easily. Please check out the demo in the attachment.
Best Regards,
Dale
v-jiascu-msftSure!
Ok sorry if I was not clear....
So let me start with what Power BI does automatically. I will use the data I have posted in the earlier reply.
If you just add that data to a matrix you will get this...
The problem is that the answers that feature 2 or more answers in the cell is treated as a unique reply.
This is what the data entry side looks like for the form....
-------------------------------------
What I was doing to seperate out the answer was to use a conditional column.
The statement looks for just part of the string and will make the new column get a value of 1 (true) if it is present in that cell.
I used "Did not capture answers to urgency question in description" for this example.
I can then sum or use the columns to make an accuracte representation of when those options are selected. Everything between a ; in the demo data are seperate selections.
I hope this cleared things up! Let me know if it is still confusing.
I really wish there was a way to let Power BI know the data in seperated by a ;
Thank you, Anonymous. It's quite clear now.
We can split the [Value] in the Query Editor. Then we can create a Matrix easily. Please check out the demo in the attachment.
Best Regards,
Dale
Was able to use that method in both excel and power bi, thank you!