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
Hi Anonymous,
I'm afraid I'm not quite clear about your scenario.
1. Why didn't you have to create a new column? How?
2. Just look at the visual, we can easily get it with the visual "Matrix".
3. I don't see any "sets a new column to true".
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!