Slicers with list

[mryoan04]

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	Red;Green;Black
564	Black
675	Yellow;Black
....	....

I want to have a list of part numbers that has certain color, for example resulting 123 and 234 for parts that has White color. 

I know I can use a text slicer or search feature on normal slicer, but I don't want the customer to type or click multiple times.

Is there any way to make a slicer based on another table with the list of the available colors? 

Available Colors

White

Green

Black

Purple

Orange

Red

Yellow

Thank you for your help, experts!

Cheers!

[Ritaf1983 · Accepted solution]

Hi @mryoan04 
Please refer to the linked video of @amitchandak :
https://www.youtube.com/watch?v=MKKWeOqFG4c

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

[Anonymous]

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.

[danextian · Accepted solution]

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.

[Ritaf1983 · Accepted solution]

Hi @mryoan04 
Please refer to the linked video of @amitchandak :
https://www.youtube.com/watch?v=MKKWeOqFG4c

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