Hi Power BI Community,
I am trying to create a table visual to show updates of the changes I have introduced in my report. The table containing the updates also includes a columns for "updateLink" in which a link to an online video may be present. I would like to create a visual that has a dynamic field containing "View video guide" as the link text and a link to the relevant video guide of the update.
I saw I can use the HTML visual but it does not let me include more than one column in the Value section. I check with Copilot and Chat GPT, they both suggested some measures to generate the HTML code to be used in the Value section of the HTML visual, however, Power BI keeps displaying errors for all measures suggested by the AIs.
Is anyone able to advise me on how to create such a table in Power BI? Be advised that my Updates table contains the following columns:
updateID which contains a unique ID for each recorded update
updateDate which contains a date when the update was recorded
updateDescription which contains the full description of the update in detail
updateLink which may contain a video link to a guide that discusses of shows the specific change
The following are examples of the measures suggested by Copilot and the errors they both display:
MEASURE
Measure_HTMLTable =
CONCATENATEX (
Updates,
"<tr><td>" & FORMAT(Updates[updateID], "0") & "</td><td>" & FORMAT(Updates[updateDate], "yyyy-mm-dd") & "</td><td>" & Updates[updateDescription] & "</td><td>" & IF(ISBLANK(Updates[updateLink]), "", "<a href='" & Updates[updateLink] & "' target='_blank'>View video guide</a>") & "</td></tr>",
"<br>"
)
ERROR:
The syntax for 'Updates' is incorrect. (DAX(CONCATENATEX (Updates,"<tr><td>" & FORMAT(Updates[updateID], "0") & "</td><td>" & FORMAT(Updates[updateDate], "yyyy-mm-dd") & "</td><td>" & Updates[updateDescription] & "</td><td>" & IF(ISBLANK(Updates[updateLink]), "", "<a href='" & Updates[updateLink] & "' target='_blank'>View video guide</a>") & "</td></tr>","<br>"))).
OR
Measure_HTMLTable =
VAR UpdateRows =
ADDCOLUMNS (
Updates,
"LinkText",
IF ( ISBLANK ( Updates[updateLink] ), "", "View video guide" )
)
VAR TableRows =
CONCATENATEX (
UpdateRows,
"<tr><td>" & FORMAT(Updates[updateID], "0") & "</td><td>" & FORMAT(Updates[updateDate], "yyyy-mm-dd") & "</td><td>" & Updates[updateDescription] & "</td><td>" & IF(ISBLANK(Updates[updateLink]), "", "<a href='" & Updates[updateLink] & "' target='_blank'>" & Updates[LinkText] & "</a>") & "</td></tr>",
"<br>"
)
RETURN
"<table border='1'><thead><tr><th>Update ID</th><th>Date</th><th>Description</th><th>Link</th></tr></thead><tbody>" & TableRows & "</tbody></table>"
ERROR:
The syntax for 'Updates' is incorrect. (DAX(VAR UpdateRows =ADDCOLUMNS (Updates,"LinkText",IF ( ISBLANK ( Updates[updateLink] ), "", "View video guide" ))VAR TableRows =CONCATENATEX (UpdateRows,"<tr><td>" & FORMAT(Updates[updateID], "0") & "</td><td>" & FORMAT(Updates[updateDate], "yyyy-mm-dd") & "</td><td>" & Updates[updateDescription] & "</td><td>" & IF(ISBLANK(Updates[updateLink]), "", "<a href='" & Updates[updateLink] & "' target='_blank'>" & Updates[LinkText] & "</a>") & "</td></tr>","<br>")RETURN"<table border='1'><thead><tr><th>Update ID</th><th>Date</th><th>Description</th><th>Link</th></tr></thead><tbody>" & TableRows & "</tbody></table>")).
In this second error, [LinkText] in the CONCATENATEX formula is specifically highlighted. When I hover on it, I see a message that says "Cannot find name '[LinkText]'"
Thanks in advance to whoever can provide me with some guidance.
