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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
gaiusgw
Helper III
Helper III

Make email addresses functional mailto links

One of my visualizations includes contact info for customer and I was wondering if it is possible to make the email column into clickable urls that start a new email? 

 

I have tried using data category to make it url but does not seem to work. 

 

Anybody have some direction for me?

 

Thanks a lot. 

 

Capture.JPG

13 REPLIES 13
jostnachs
Helper III
Helper III

Is there a way to remove "mail to" and only have the email id as a link?

jostnachs_0-1722538814372.png

 

Hi @jostnachs,

 

The previous response I added to this thread shows email addresses without the mailto... although I didn't post an image of it doing that 🙃

PC-BI
Frequent Visitor

Hi @gaiusgw,

I'm sure you've sorted this by now, but in case any one else comes across this post, here's what I did to show working email addresses without the mailto: bit showing:

  • Right click on the data source on the right and select New Column
  • enter the DAX to concatenate 'mailto:' before the email address: 

 

Email link = CONCATENATE("mailto:", DataSource[Email])​

 

  • Select the table visual that you are displaying the original (non concatenated) email address in
  • Go over to Format your visual
    PCBI_1-1711106106102.png
  • Scroll down to Cell elements and expand it
  • Select 'Email' from the dropdown under the Series heading
  • Turn on Web URL
  • Click the fx button and choose the newly created 'Email link' column under 'What field should we base this on?' heading
  • Click OK
  • The emails should now show as links and can be clicked on when published

Things to note

  • If you have multiple email addresses in a cell at the source, they should be separated by semicolons ;  - your chosen email program may throw an error otherwise
  • If the process above hasn't worked, check that both the email and email link columns are set to uncategorised in the data category PCBI_2-1711106391117.png

     

Good luck 🙂

I tried this and i still see mailto

Hi @jostnachs ,

In the table visual where you are showing the email addresses, are you using the non-concatentated/original email address field from your original data?

You only need to use the concatenated column for the Web URL link bit.

Hope that helps 🙂

Hi,

 

I followed the exact steps given by you. but then i see along with the mail to 😄 dotn know what i missed.

Hi @jostnachs ,

Hmm, can you create the table with the normal email address from your data (without the link)? 
 

V-lianl-msft
Community Support
Community Support

Hi @gaiusgw ,

 

Please add "mailto:" to the mail address:

Email = CONCATENATE("mailto:",'Table'[Mail])

Vlianlmsft_0-1650335921651.png

 


Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Adding mailto: in front of emails in an added column does work but it is not the most elegent solution persay. And any lines that do not have an email will appear as just mailto:. It would be strange if powerbi cannot recognize emails and make them clickable. 

Hi @gaiusgw ,

 

Try work with IF function.

IF(ISBLANK([Mail]),BLANK(),CONCATENATE("mailto:",'Table'[Mail]))


Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

That did not work. mailto still appeared. Perhaps because those empty cells really have space characters? 

davehus
Memorable Member
Memorable Member

Hi @gaiusgw, There is an element that might need to be turned on in the visualization settings, see below.

 

davehus_0-1649890844784.png

 

Hmm, i do not have that panel as far as I can tell. I am on version 2.91.7 and honestly nervous to update. 

 

Here is what my panel looks like. 

 

on another note, if i did update, do you know of any place i can download the version i have now? I have search for archives but cannot fine one. 

 

Capture.JPG

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.