Splitting data with overlapping values and then collating into a chart

briwhiz23 

You have to create new rows to do this.  Creating new rows will mean your data is in a tabular format which is what you need for analysis.

In Power Query when you split the names by delimiter, in the Advanced options choose to create new rows, rather than columns

Regards

Phil

Thanks for the reply from PhilipTreacy , please allow me to provide another insight: 
Hi  briwhiz23 ,

I created some data:

Here are the steps you can follow：

1. You can create a calculation table containing the data needed for the X-axis of the clustered column chart.

2. Create measure.

Measure =
var _vtable=
DISTINCT(
FILTER(
    CROSSJOIN(
        'Table','Group_Table'),
  FIND( 'Group_Table'[Group],'Table'[ASSIGEND TO],,BLANK()<>BLANK())))
return
COUNTX(
    FILTER(
        _vtable,[Group]=MAX('Group_Table'[Group])),[ASSIGEND TO])

3. Result:

Best Regards,

Liu Yang

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