Common Delimited Values Into Slice

[Pklu]

Hello Everyone,

I have the following Table with common delimited values:

Drawer Name	Invited Country	Actual Country
Malcom Keys	Angola, Armenia, Bosnia and Herzegovina, Brazil, Cameroon, Colombia, Comoros, Djibouti, Ecuador, Egypt, Georgia, Ghana, Guatemala, Iraq, Jordan, Kenya, Kosovo, Lebanon, Morocco, Mozambique, Nepal, Oman, Peru, Philippines, Panama, Sri Lanka, Turkiye, Thailand, Trinidad and Tobago, Yemen, Zambia, Australia, Austria, Bahrain, Canada, France, Germany, Greece, Israel, Italy, Kuwait, Netherlands, New Zealand, Oman, Poland, Qatar, Saudi Arabia, Spain, UAE, UK	Armenia, Brazil, Cameroon, Canada, Djibouti, Ecuador, Egypt, Ghana, Guatemala, Indonesia, Iraq, Italy, Jordan, Kenya, Kosovo, Morocco, Mozambique, Nepal, Philippines, Qatar, Saudi Arabia, Sri Lanka, Thailand, Zambia
Grady Michaels	Australia, Austria, Bahrain, Canada, France, Germany, Greece, Israel, Italy, Kuwait, Netherlands, New Zealand, Oman, Poland, Qatar, Saudi Arabia, Spain, UAE, UK	Djibouti, Ecuador, Egypt, Georgia, Ghana, Guatemala, Iraq, Jordan, Kenya, Kosovo, Lebanon, Morocco, Mozambique, Nepal, Oman, Peru, Philippines, Panama, Sri Lanka, Turkiye
Florence Maddy	India, Madagascar, South Africa, Dubai, Wales	Wales, Dubai
George Mills	Iceland, Norway, Finland, Scotland, Germany	Nory, Finland, Germany

I would like to make two slices (Invited country and Actual Country) to filter out the result:

As of now the slice when setup looks like the following:

Invited country slice dropdown:

Angola, Armenia, Bosnia and Herzegovina, Brazil, Cameroon, Colombia, Comoros, Djibouti, Ecuador, Egypt, Georgia, Ghana, Guatemala, Iraq, Jordan, Kenya, Kosovo, Lebanon, Morocco, Mozambique, Nepal, Oman, Peru, Philippines, Panama, Sri Lanka, Turkiye, Thailand, Trinidad and Tobago, Yemen, Zambia, Australia, Austria, Bahrain, Canada, France, Germany, Greece, Israel, Italy, Kuwait, Netherlands, New Zealand, Oman, Poland, Qatar, Saudi Arabia, Spain, UAE, UK

Australia, Austria, Bahrain, Canada, France, Germany, Greece, Israel, Italy, Kuwait, Netherlands, New Zealand, Oman, Poland, Qatar, Saudi Arabia, Spain, UAE, UK

India, Madagascar, South Africa, Dubai, Wales

Iceland, Norway, Finland, Scotland, Germany

Actual Country slice dropdown:

Armenia, Brazil, Cameroon, Canada, Djibouti, Ecuador, Egypt, Ghana, Guatemala, Indonesia, Iraq, Italy, Jordan, Kenya, Kosovo, Morocco, Mozambique, Nepal, Philippines, Qatar, Saudi Arabia, Sri Lanka, Thailand, Zambia

Djibouti, Ecuador, Egypt, Georgia, Ghana, Guatemala, Iraq, Jordan, Kenya, Kosovo, Lebanon, Morocco, Mozambique, Nepal, Oman, Peru, Philippines, Panama, Sri Lanka, Turkiye

Wales, Dubai

Nory, Finland, Germany

I would like to get the slices to look like:

Invited Country and Actual Country

Angola

Armenia

Austria

Australia

Bahrain

Chad

Cameroon

Canada

Each country on its own ...

So when I select a country from the dropdown it will look for the match and display the rows with all the information (Drawer Name, Invited Country and Actual Country.

Thanks in advance.

[Ritaf1983]

Hi @Pklu 
If the requirement is to select from a list, the data structure should also be in a list format rather than concatenated, as shown in the image you provided.
In such a case, you can download a text box slicer from the marketplace and use it.

The pbix with the example is attached

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

[Pklu]

Thank you so much. That helped but I actually need the items in the table format so I can create another slicer to select the country they want to view other information partaining to that specific country.

Really appreciate your reply and sorry for the long delay to reply.

[Ritaf1983]

Hi @Pklu , I in doubt that it is possible...
The table can be as in your images, but the slicer should be a list as I showed...

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