Creating a custom region for "Location" on a fill map

[raymond_z_hu]

Hi everyone! I'm having trouble creating a fill map. 

I currently have data for certain clients that correspond to certain predetermined regions (West, northeast, northwest) that I would like to project onto a map- and obviously separate them by region. i.e. Client A- Northeast; Client B- West; Client C- Northeast.  Right now, PowerBI recognizes the region names as random places in the world (Central shows up as Central, Paraguay, when I want to customize central to be the aggregation of Indiana, Ohio, Michigan etc.)

Most help posts have said to place "state" into Location and then  "region" into Legend but the client data corresponds to a larger region, not a state. How would I create a custom region that could fit in "location" and link that to data of the client? I've tried something along the lines of creating a separate data table with the states that go into each region and then linking the region to my original dataset but it doesn't quite work. Any help on this would be greatly appreciated!

[v-huizhn-msft]

Hi @raymond_z_hu,

Your sample table is like as follows: Client A- Northeast; Client B- West; Client C- Northeast. You want to separate the client data(ClientA, ClientB, ClientC) and location(Northeast,West,Northeast etc), right? If it is, please refer to this thread or this article. Then create the map using data. 

Or review the following idea and vote them if they are inline with yours.

Filled map - show County, Country/Region, State/Province on a single map
It is hoped that the map will support the region

Best Regards,
Angelia

[raymond_z_hu]

Thanks for the reply @v-huizhn-msft. The first part is not the issue- all of the data has already been organized properly.

The issue is that the Location field only recognizes set partitions like state, country, etc. when I need it to recognize custom regions (Northeast=NY + NJ + Delaware + MA...) without visually breaking them down into states on the map since each row of client data corresponds to a region, not a state.

[v-huizhn-msft]

Hi @raymond_z_hu,

You want to show custom regions (Northeast=NY + NJ + Delaware + MA...), which is not recognize in the map. Please review the following ideas and vote them.

Allow for easier creation of custom regional maps
Allow creation of custom map regions by grouping ZIP Codes

Best Regards,
Angelia