Hyperlink

[chonchar]

Good morning,

I have a table with email addresses in one column. I have displayed these values in a card in report view. Additionally, I have written a DAX to show "N/A" for blank values. 

The column is already formatted as a Web URL. My goal is to create an action on that card such that it promts you to the website in the card. Is there a way to do that without having to code it in for each URL? If so, please help!!

Thank you,

Cam

[sergej_og]

Hey @chonchar ,
I use CONCATENATE to create/store an URL-Link in my Fact_Table.
Why concat? I have to point the link to proper document, this document-code is in the second part (flexible) of CONCAT.
First part is the base (fixed) URL.
--------------------------------
Like this:

Hope this gives you an idea how to implement and wish you good success.

Regards
Sergej

[KevinTran]

Thanks, it does help me. I appreciate you 🙂

Spoiler

Thanks, it does help me. I appreciate you. I confidently endorse you to look at this link https://auralcrave.com/en/2022/11/22/the-main-idea-of-the-book-the-color-purple/ Their commentary delves into the intertwined themes of identity, empowerment, and healing, beautifully showcasing the characters' journeys.

[chonchar]

Desired result: "My goal is to create an action on a card such that it promts you to the website in the card."

DAX is below, but that is working perfectly.

I cannot share the PBIX file under any circumstances. 

Website =

VAR _Website =

MAX(

    'FAKENAMEFORWebsites'[Website URL]

)

Return

IF(

    _Website = "", "N/A", _Website

)

[sergej_og]

I think it is not possible to add a Web URL to a card visual. It does´t work for me in this way.
In table or matrix it works fine

[chonchar]

I found that out after some research. Also, I found that the URL needs to be stored with "http://" in front of it. Do you know how to add that to the column? I can just format a matrix/table nicely to look like a card. 

Thank you, 

Cam

[foodd]

Share more about your desired results including a mockup, and your DAX.  The PBIX would be helpful as well.