Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Evogelpohl
Helper V
Helper V

ArcGIS - Help - Georgia is in the US

Using the new ArcGIS, I have sales data for all 50 US states.  When using the Location Type = 'Points' representation, how do you force Georgia back into the US?

 

You can see I've set my Country filter to US (though there are no other countries in my data set), but that didn't work.

 

???

Screen Shot 2016-10-03 at 7.11.15 PM.png

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

@Evogelpohl

 

It seems you have to create another column and concatenate => state, country and use this column in the Location.

 

State, Country = 'Table'[State]&", "&'Table'[Country]

By the way if you use State abbreviations the Map get even crazier => look at the bottom Map

 

2016-10-03 - ARCGIS Test.png

 

Clearly this is the first (preview) release and as such many things are missing...

As was pointed out in another post the first thing I noticed too was NO TOOLTIPS Smiley Sad

View solution in original post

2 REPLIES 2
Sean
Community Champion
Community Champion

@Evogelpohl

 

It seems you have to create another column and concatenate => state, country and use this column in the Location.

 

State, Country = 'Table'[State]&", "&'Table'[Country]

By the way if you use State abbreviations the Map get even crazier => look at the bottom Map

 

2016-10-03 - ARCGIS Test.png

 

Clearly this is the first (preview) release and as such many things are missing...

As was pointed out in another post the first thing I noticed too was NO TOOLTIPS Smiley Sad

@Sean, thanks.  

 

 

Yeah, I concatenated "City + St" and I ended up with 'Virginia Beach, VA' in Australia.  

 

A work in progress but glad it's here.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.