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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
andrmh
Helper II
Helper II

Map Visual - Australian Data

Hi all,

 

Another one that should be very simple but we are struggling with.

 

We are using at this stage, the 'Map' visual, for our data samples, the ARCGIS map wond do just yet (we are at proof of concept stage - not wanting to pay the premium just yet)

 

I can get the filled map to work when its just state and country combined as '[State], [Country]'

But we are really interested in getting down to the postcode level.

 

map data sample.PNG

Small sample of the data.

 

What is the correct notation to supply to the map when we only have postcode, state, and country available?

At this stage our data samples do not provide long/lat.

 

Could it be that errors in the data throw off the whole thing (see above postcode 20048 - Clearly invalid in Australia)

 

Any thoughts or tips appreciated.

3 REPLIES 3
Archie1
Frequent Visitor

Hi @andrmh,

 

Initially, I had same issue however I got a soultion for us all by using Map visualization.

 

Steps:

- Create a custom column by concatenating state and country. eg: CustomState - Country 

- For above custom column, set Data Category  = Place 

- Under visualizations, Select "Map"

- Drag "CustomState - Country " field to location.

 

Please see below screen for more details:

All suburbs on Australia map.PNG

Hope it solves your issue.

 

Cheers,

Archie1

 

v-chuncz-msft
Community Support
Community Support

@andrmh,

 

You may take a look at Tips and tricks for Power BI map visualizations.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
andrmh
Helper II
Helper II

I've since read https://community.powerbi.com/t5/Desktop/Problem-with-map-and-postal-code/m-p/11072#M2409

and it was not able to solve my problem.

 

I have since tried combinations of:

country, postcode

postcode, country

postcode

a 'upside down' hierarchy of postcode, state, country

postcode, state, country

state, postcode, country

country, postcode, state

 

None of these combinations seem to work.

 

The result is a little better (though still not correct)

when I add state as the top level, and drill down into postcode

 

when i drill strange things happen that put 2000 in europe, not over Sydney, even though the state was 'New South Wales'

 

I suspect something is wrong with bing maps. Not sure what.

The ESRI solutions is superior functionally, however at its price points and for our data samples clipping the 1500 plot limit, its not an option.

 

If anyone is able to shed any light on this it'd be appreciated.

 

Thanks

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors