topic Re: How to Render DAX Measure with Hyperlinks in Power BI Matrix Visual? in DAX Commands and Tips

How to Render DAX Measure with Hyperlinks in Power BI Matrix Visual?

PSA — Wed, 23 Oct 2024 11:05:52 GMT

Hello Power BI community,

I am trying to create a DAX measure that combines multiple ISSUE_KEY values from Issues table into a string of clickable hyperlinks. The goal is to concatenate the values and display them as individual links in a Power BI Matrix visual.

I have the URL saved in Issues[ISSUE_URL] but the display text should be Issues[ISSUE_KEY]

Here is the DAX measure I’m using:

CombinedIssuesWithLinks = CONCATENATEX( Issues, // Something like HYPERLINK(Issues[URL],Issues[ISSUE_KEY]) "<a href='" & Issues[URL] & "' target='_blank'>" & Issues[ISSUE_KEY] & "</a>", UNICHAR(10) // To add a line break between links )

However, when I add this measure to my Matrix visual, Power BI does not render the hyperlinks but instead displays the raw text.

My questions are:

Is it possible to render HTML or clickable hyperlinks in a Matrix or Table visual using DAX in Power BI?
If not, are there any workarounds to display concatenated hyperlinks in a way that Power BI will recognize them as clickable links?
Is there any way to create dynamic rows inside a matrix cell if more than one value exists? For example, if there are multiple ISSUE_KEY values, can I dynamically add separate rows within a single matrix cell?

I would appreciate any advice or solutions that can help me achieve clickable hyperlinks or similar dynamic row behavior within a matrix or table cell in Power BI.

Re: How to Render DAX Measure with Hyperlinks in Power BI Matrix Visual?

shafiz_p — Wed, 23 Oct 2024 12:10:52 GMT

Hi PSA Rendering HTML or clickable hyperlinks directly in a Power BI Matrix or Table visual using DAX measure is not supported. However, you can achieve clickable hyperlinks by using calculated column and change the data category to Web URL. See image below:

This is clickable. It will redirect to the website.

Hope this helps!!

If this solve your problem, please accept it as a solution!!

Best Regards,
Shahariar Hafiz

Re: How to Render DAX Measure with Hyperlinks in Power BI Matrix Visual?

PSA — Wed, 23 Oct 2024 12:24:22 GMT

Hi Shafiz,

Yes, i can display the whole URL directly. But what I want is to only display the Text.

Something like the following where Display text 1 and Display Text2 has got two diffent links.

Re: How to Render DAX Measure with Hyperlinks in Power BI Matrix Visual?

Anonymous — Thu, 24 Oct 2024 03:08:32 GMT

Thanks for the reply from shafiz_p, please allow me to provide another insight.
Hi PSA ,

Below is my sample data.

Create a measure.

CombinedIssuesWithLinks = SELECTEDVALUE(Issues[ISSUE_KEY])

Place the ISSUE_KEY field with the measure in the table visual.

Go to Table Visual Format->Visual->Cell Elements->For Apply settings to select the measure, find the Web URL and set it to On.
In the Web URL dialog box, select the ISSUE_URL field.

In this way, the measure becomes a clickable hyperlink text pointing to the corresponding link.

You can also refer to the following link for more information.

Add hyperlinks (URLs) to a table or matrix - Power BI | Microsoft Learn

Please see the attached pbix for reference.

Best Regards,
Dengliang Li

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

Re: How to Render DAX Measure with Hyperlinks in Power BI Matrix Visual?

PSA — Thu, 24 Oct 2024 06:59:06 GMT

Hi Dengliang,

I have tried this method but it either takes the first or the last value. I have multiple values and i want to concatenate them to a single value with correct URL.

Re: How to Render DAX Measure with Hyperlinks in Power BI Matrix Visual?

Anonymous — Fri, 25 Oct 2024 08:26:24 GMT

Hi PSA ,

I'm afraid that's not possible.
After testing, multiple URL values in a cell in table visual and matrix visual will be rendered as an illegal and invalid URL.

You can only select a URL value to take effect with some settings (First/Last).

Best Regards,
Dengliang Li

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