Table field with more than one record

Hi Syndicate_Admin ,

In Power Query, you can create a table to relate zone to each delegacion. For that, you can create a "reference" to the original table, and then follow the steps below:

1. Create a reference:

2. Split Columns By Delimiter (in you case I believe its comma):

3. Select all columns that are not the "splitted" delegaciones and select tranform > Unpivot Columns > Unpivot Other Columns:

4. You can TRIM the text to remove leading spaces:

5. Remove the 'Attribute' column, and then you have all delegaciones in rows to use for filtering. For that, you just need to create a relationship to your original table (consider using bridge tables to avoid many-to-many relationships).

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️or giving it a kudoe 👍

Thanks!
Best regards,
Joao Ribeiro