Forum Discussion
Data slicer using data divided by delimiterer
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 |
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
3 Replies
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
Hello @dharmendars007,
Thank you for the response! How can I filter by row? I know only how to use data slicer for columns
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.
