Skip to main content
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.

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.

Frequent Visitor

Hi @andrmh,


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



- 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.





Community Support
Community Support



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.
Helper II
Helper II

I've since read

and it was not able to solve my problem.


I have since tried combinations of:

country, postcode

postcode, country


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.



Helpful resources

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


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.