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.
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:
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
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
Any ideas on this mate? It has only started to be an issue this financial year.
Adam
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
@RobbeVL Thanks. That worked.
I does mean that we don't get our referenced layers displaying from ArcGIS
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |