Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |