hyperlinks
1 Topic
How to Render DAX Measure with Hyperlinks in Power BI Matrix Visual?
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.Solved2.8KViews0likes5Comments