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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
TommyFred
New Member

Concatenate interfering with maps, and duplicate results

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?

1 ACCEPTED SOLUTION
TommyFred
New Member

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.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

@TommyFred,

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

Regards,
Lydia

TommyFred
New Member

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.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.