Group locations as territory

[Jamesapstott]

I have data in the form: Territory Name | Zip/Postcode that assigns multiple zip codes to a single territory. I want to map the territories as areas in a filled map but haven't found much success in Power BI. I have tried using a hierarchy structure in the data which didn't achieve what I wanted; I've also tried putting both the Territory Name alongside the zip code in the "Location" field for the map, again to no avail.

Does anyone know how to achieve this?

Thanks.

[v-xjiin-msft]

Hi @Jamesapstott,

Please share us your source table structure and some sample data (which we can copy and paste directly) and the corresponding expected result. Otherwise, it is hard for us to understand your requirement.

Thanks,
Xi Jin.

[Jamesapstott]

I have data in the form: Territory Name | Zip/Postcode that assigns multiple zip codes to a single territory. I want to map the territories as areas in a filled map but haven't found much success in Power BI. I have tried using a hierarchy structure in the data which didn't achieve what I wanted; I've also tried putting both the Territory Name alongside the zip code in the "Location" field for the map, again to no avail.

Does anyone know how to achieve this?

Thanks.