create slicer with single countries from column with multiple delimited countries in a row

[Anonymous]

Hi everyone,

I have a variable/column ('CountryActivity') where repondents had to indicate in which countries they are active. Now most of them are active in multiple countries and 'CountryActivity' now figures multiple countries delimited by a semicolon.

 

I want to be able to create a slicer for a visulaized table with the respondents names (companies) that filters for the single country activity (being able to choose Canada and then seeing the companies that contain Canada in the 'CountryActivity' coumn). When I use 'CountryActivity' I off course only get wild country mixes as options to choose from to filter my table output.

I tried working with parameters and setting up a table with the single country names as filter but couldn't get to a solution. How would you go about it? I'm a beginner and at the end of what I can imagine...

Thanks in advance!

Adam

[dax]

Hi @Anonymous , 

If your slicer is single slicer, you could try to refer to my sample for details.

Best Regards,
Zoe Zhi

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

[amitchandak]

@Anonymous , see if you can split the columns into rows and that allows you better analysis

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

[nandukrishnavs]

@Anonymous 

Split your column into rows 1st, then use that column for the slicer.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂