Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
My data contains more than one item for one field. ie.
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!!
Go to 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
View solution in original post
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.