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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

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?

 

 

address.JPG

 

 

Thank you guys!!

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

 

This calculated column formula should work

 

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

 

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

4 REPLIES 4
v-yuezhe-msft
Employee
Employee

@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

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.
Anonymous
Not applicable

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

Ashish_Mathur
Super User
Super User

Hi,

 

This calculated column formula should work

 

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

 

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Thank you!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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