Concatenate interfering with maps, and duplicate results

[TommyFred]

Hi all

I've found something weird that I'm trying to figure out. If I create a map with the data I have adding suburb, post code, state and country informationfrom individual columns, it works, but it shows locations all around the world, not just in the country I've selected.

However, if I try to create a map visualisation from the information in one column using concatenate functions, nothing shows up at all.

This is the code in question. [Postcode] & ", " & [Suburb] & ", Sydney, Australia"

Any idea why these things are happening?

[v-yuezhe-msft]

@TommyFred,

Glad to  hear the issue is solved, you can accept your reply as answer to close this thread.

Regards,
Lydia

[TommyFred · Accepted solution]

Alright, I figured it out myself. There might be a bit of glitching going on, but this this but the formula works. I just needed to catagorise the column as place, and catagorise the suburb and post code correctly.