Forum Discussion

mryoan04's avatar
mryoan04
Frequent Visitor
1 year ago
Solved

Slicers with list

Hi, I have this question.   I have this kind of data. Each part numbers has different colors with ; delimiters. Part Number Colors 123 White;Green;Blue 234 Purple;Orange;White 334 ...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi mryoan04 

     

    Create a custom in Power Query with this formula:

    Text.Split([Colors], ";")

    This wil create a list of values from the Colors column. Expand that into new rows.