Split a row based on label contents

[GlynMThomas]

Hi,

I have a data source of incidents that I've loaded into power bi from jira, One of the columns is a label column, this dictates what type of work the incident was about (report, account query, letter, etc). Sometimes however the label includes 2 values split by a semicolon (an example of this would be report;account query). I'm trying to build a pie chart to show how many tickets we've had under each type of work label, and where the label contains 2 items of work it should be included in the count of both those work items even though it's only one row.

Is there a way to do this in power bi using a measure?

[v-eqin-msft]

Hi @GlynMThomas ,

Agree with @amitchandak .You could firstly split column by "," to rows:

Then right-click the column to remove all spaces. In addition, I add a Index column 

Output:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@GlynMThomas , if possible then you should use split by a delimiter in Power query and split into rows

Split Column Power Query: https://youtu.be/FyO9Vmhcfag