Forum Discussion
Dissecting Multi-pick fields
Hi,
My data contains more than one item for one field. ie.
| CR ID | Potential Impact |
| 1 | Scope, Resources |
| 2 | Schedule,Scope,Resources |
| 3 | Resources,Cost,Schedule |
| 4 | Resources |
What i would like to do is understand how many times each potential impact choice was selected. ie. how many time was Resources was selected.
I would then like to display that in some sort of visual chart in a report.
There are up to 7 choices a user can select from and the field is optional so field can be blank also.
Any help appreciated!!
Amy79 , In power query use split by delimiters with row option you will get additional rows for each of the CR ID.
You can use this model to count words
Split Column Power Query: https://youtu.be/FyO9Vmhcfag
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
1 Reply
Amy79 , In power query use split by delimiters with row option you will get additional rows for each of the CR ID.
You can use this model to count words
Split Column Power Query: https://youtu.be/FyO9Vmhcfag
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/