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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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