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.

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, mryoan04 

May I ask if you have gotten this issue resolved? If it is solved, please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.


If it is not resolved, I hope you will provide the full .pbix file via OneDrive or SharePoint. Please be careful to remove all sensitive information and we will do our best to provide ideas for your issue.

 

 

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.