Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!!
Solved! Go to Solution.
Hi,
This calculated column formula should work
=[address]&" "&[City]&" "&[State]&" "&[zip]
Hope this helps.
@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
Hi,
This calculated column formula should work
=[address]&" "&[City]&" "&[State]&" "&[zip]
Hope this helps.
Thank you!