Forum Discussion
Common Delimited Values Into Slice
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.
3 Replies
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.
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.
