Create a slicer based on separate parts of a string

[Quiny_Harl]

This is my table:

Each ID has several markets separated by coma. I need a slicer where the entries will be like 1. IT 2. UK 3. GR, instead of the whole string.

[amitchandak]

@Quiny_Harl , try split of the column into rows or column if that can help

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

[vanessafvg]

Are you wanting to split them into separte columns, or in the same column but in separate lines? in power query (transform data option) you can split by delimimiter using your comma (,) to create columns.

[Greg_Deckler]

@Quiny_Harl - You will have to split that column out and then unpivot the resulting columns in order to get something that you could use in a slicer.

[Pragati11 · Accepted solution]

Hi @Quiny_Harl ,

You can do following:

1. Go to Query Editor
2. Select your "Main Markets" column
3. Click on Transform --> Split Column --> By Delimiter  as shown below:

You will end up with multiple columns, having all the values from "Main Markets" column; that are now split by ",". Use these columns as filter on your report.

Thanks,

Pragati