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
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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Kudoed Authors