concatnate 4 columns into an address and make it linkable to a bing map

[Anonymous]

Hi Community,

I have 4 columns each containing a piece of an address.  PowerBI's concatnate function only allows for 2 values.

First, how can I concatnate all 4 cells so that the output is = 1234 Well Road Los Angeles CA 93257

Next, assuming the concatnate can be done, how can I make the newly created column a clickable address that will be located on the bing map visual?

Thank you guys!!

[v-yuezhe-msft]

@Anonymous,

Currently, it is not possible to add a clickable address in the newly created column as you describe, you are able  to create hyperlink in Power BI Desktop using table/Matrix/textbox as described in this article. 

IIn Power BI Desktop, you can consider to use drill through feature to navigate to map visual.

Regards,
Lydia

[Anonymous]

@v-yuezhe-msft, thanks for your response. 

[Ashish_Mathur · Accepted solution]

Hi,

This calculated column formula should work

=[address]&" "&[City]&" "&[State]&" "&[zip]

Hope this helps.

[Anonymous]

Thank you!