Data slicer using data divided by delimiterer

[LucasResendeR10]

Hello guys!

I'm having trouble creating a data slicer. I have the sample data below, where in the first column, we have different terms divided by a delimiter, the ",". Each of the following columns are values brought by those terms in the first column, while the last column is the sum of those four columns. I want to create a data slicer where I can filter the Total Limit based on the Banks column, but I'm having trouble because those terms are separated by a delimiter, so the power bi identifies them as just one term. I can't separate them in lines. 

Banks	Limit Banco Original	Limit Banco de Brasília	Limit Banco do Brasil	Limit Caixa Economica	Total Limit
Banco Original, Banco de Brasília, Banco do Brasil, Caixa Econômica	1	1	1	1	4
Banco Original	1				1
Banco Original	1				1
Caixa Econômica	1				1
Banco Original, Banco de Brasília, Banco do Brasil, Caixa Econômica	1	1	1	1	4
Banco do Brasil, Caixa Econômica			1	1	2
Banco do Brasil			1		1
Banco do Brasil			1		1
Banco do Brasil			1		1
Banco do Brasil			1		1
Caixa Econômica				1	1
Caixa Econômica				1	1
Caixa Econômica				1	1
Caixa Econômica				1	1

[v-linyulu-msft]

Thanks for the reply from dharmendars007 r, please allow me to provide another insight:

Hi, @LucasResendeR10 

You can also try the following custom visual object, which can quickly filter rows based on the content you input:

Of course, if you have any new ideas, you are welcome to contact us.
 

Best Regards,

Leroy Lu

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

[dharmendars007 · Accepted solution]

Hello @LucasResendeR10 , 

Please select the column "banks" and use "Split by delimiter" option in Power query to split the column values by "," and then based based on the rows with all the values use it as slicer.

https://learn.microsoft.com/en-us/power-query/split-columns-delimiter

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[LucasResendeR10]

Hello @dharmendars007,

Thank you for the response! How can I filter by row? I know only how to use data slicer for columns