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
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?
Solved! Go to 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.
@TommyFred,
Glad to hear the issue is solved, you can accept your reply as answer to close this thread.
Regards,
Lydia
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.
User | Count |
---|---|
123 | |
96 | |
89 | |
73 | |
63 |
User | Count |
---|---|
138 | |
115 | |
111 | |
98 | |
95 |