Dissecting Multi-pick fields

[Amy79]

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!!

[amitchandak · Accepted solution]

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