ArcGIS Widget Continues to Move From AUS to USA

[tiztrain]

Hi,

I have previously been using a state field to highlight different states in Australia. User could select the state and the results on the report would change. For some reason, this has changed and the ArcGIS widget keeps defaulting to New Hampshire in the US and states that it "Failed to locate 4 features"

The values that I have in my state field are:

• New South Wales
• Northern Territory
• Queensland
• Victoria
• Western Australia

It seems like it links New South Wales to New Hamshire and then has errors with the rest of the values. 

I have tried creating a column where I combine the State name and "Australia" at the end but then I get the following error:

It is annoying because it has previously worked great but now all of the sudden is causing issues.

Anybody got any good ideas?

Cheers

[RobbeVL]

A Simple fix could be to add "Country" above the "axis" hierarchy. Even if you dont need it.

If you dont have that field, simply create a calculated column "Australia".

hope this helps.

Robbe

[tiztrain]

Any ideas on this mate? It has only started to be an issue this financial year.

Adam

[RobbeVL]

Have a look at this visual.

Pretty sure it would be a better for your dashboard.

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-shape-map 

I think australia is also one of the built in functions.

Robbe

[tiztrain]

@RobbeVL Thanks. That worked.

I does mean that we don't get our referenced layers displaying from ArcGIS

[tiztrain]

Thanks @RobbeVL 

Am I missing something though cause when I try to add my calulated column it overwrites the state field in Location? I can't get it to be the first level of the hierarchy?