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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@TommyFred,

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
October NL Carousel

Fabric Community Update - October 2024

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