Filled Map custom Regions

[sajarac]

Hi There, I have been trying to create a filled map with no luck and I hope someone can point me in the right direction.

In my data I have a column with the Sales Representatives and the regions that they represent located in US and Canada, but the filled map only recognizes the Ontario region, because the other regions has names such as Gulf Coast, Mountain Region, etc. is any way to map this?

Thanks in advance for any advice,

regards

[v-yuta-msft]

Hi sajarac,

You can change layers in power bi service. Please refer to:

https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-arcgis#features-overview

Regards,

Jimmy Tao

[sajarac]

Hi there, and thank you very much for you prompt reply. However, are you sure that this tool "Argis" is suitable for what I need?

I've been playing around and I cannot figure how to organice my data by regions, could you please provide a little bit more information? 

Thanks in advance

[Hardik]

https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-filled-maps-choropleths

I hope this helps

[sajarac]

Help, help, help!!!!!!

Please, I am getting mental with this, it seems like none of the options works with my data.

Please any other sugestion?

Thank you kindly

[sajarac]

Hello, any guru that can help me?

Still trying to figure out this with no solution so far. my list is sorted like this:

Sales Rep          |       Region

SalesRepSalesRep

SalesRepID SRName Region Email Active

1	Select	Northwest		Yes
2	Sales Rep A	West Central		Yes
3	Sales Rep B	East Central		Yes
4	Sales Rep C	North East		Yes
5	Sales Rep D	Great Lales		Yes
6	Sales Rep E	Mid Atlantic		Yes
7	Sales Rep F	Mountain		Yes
8	Sales Rep G	Western Canada		Yes
9	Sales Rep H	Gulf Coast		Yes
10	Sales Rep I	Southern		Yes

And for instance Great Lakes are OH, MI, WI and IL.

How can I plot in the map this? 

thanks in advance for any response.

Regards

[cgk]

I am not a guru, but this worked for me.  I have a data dable that lists the states, the region the states are in (such as 1 thru 5), and the regional manager for each state.  By selecting the region or regional manager as the primary filter, the map fills in based on the numberical value for each region.  Hopefully this makes some sense to you.

[sajarac]

Hi there, and thank you very much for your reply.

Your solution work, but my problem is for instance in the map I have to split California in two and others states also. that is why I have to use a custom map.

I found the solution in the follwoing post using the synoptic panel and the synoptic designer.

thanks again.

Regards

Synoptic panel:

https://okviz.com/blog/introducing-synoptic-panel-v1-4/

Synoptic Designer:

https://synoptic.design/

[jmhoskinson]

I know I'm a little late to this thread, but I was able to use Filled Maps to subdivide a state. I created a column that had county level data (how I needed to divide my states) for only the states I needed to split up and just state level for other states. I then gave that column a data category of place. PBI mapped everything perfectly. Hope that helps with your problem next time it comes along!

[sajarac]

Never is too late, Thank you very much!!