cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ianmonat Regular Visitor
Regular Visitor

Power BI map help - US States

Hi, I'm creating a Power BI report using the free web version. My data source is an Excel spreadsheet on Sharepoint.

 

I'm trying to use a map vizualization to display sales by state in the US.

 

It's pretty simple except that in my organization, California is split into Northern and Southern California. I have to keep Northern California and Southern California separate.

 

Any tips on how to display this mix of states and state-parts on a map? The map is not recognizing Northern or Southern California.

 

I have tried the Map, Filled Map and ArcGIS map. Thanks for any tips you may have. 

4 REPLIES 4
cs3122 Regular Visitor
Regular Visitor

Re: Power BI map help - US States

I'd like to know if there is a solution to this to...we do the same in my organization. I've used other Microsoft products such as PowerView, which also do not support the ability to split up states by 'markets' or other DMA designations. It would be nice if there was a way to tie a ZIP code file to define these geographic areas.

Sacha Regular Visitor
Regular Visitor

Re: Power BI map help - US States

Take a look at the ShapeMap visual.  It's currently in Preview but this should allow you to achieve the required results:

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-shape-map/

 

HTH

Sacha

 

ianmonat Regular Visitor
Regular Visitor

Re: Power BI map help - US States

Thank you for the reply, I did read about shape maps but i understand they are for Power BI Desktop files only and I am trying to keep this report in Power BI web service.

Moderator v-yuezhe-msft
Moderator

Re: Power BI map help - US States

Hi @ianmonat,

You can create ShapeMap visual in Power BI Desktop and publish your report to Power BI Service following the instructions in this article:https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-upload-desktop-files/.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors