Matrix conditional formatting

[wes11]

Hello! I am attempting to create a matrix that displays a dot based on values that are in a comma delimited column (Fig. 1).  How may I display these distinct values across the top of a matrix and indicate each meal that may contain that item (Fig. 2)?

Fig. 1

Fig. 2

Thank you!

[wes11]

Thank you @stevedep!

[wes11]

Thanks @stevedep.  Sorry, I do have these in a lookup table that is linked to the source table.

[stevedep · Accepted solution]

Ok, you can keep that table unrelated, and in DAX use INTERSECT to check for the presence and then count, when > 0 then you column needs to be populated. 

[stevedep]

For starters in Power Query; spilt column by delimiter (comma) and use these row values next.