Solved: HTML

Janewhite · ‎08-15-2023

Hi all, please is it possible to call a Varable in a Html code, if so how please

Measure 3 =

VAR name_ = USERNAME()

return

"

<!DOCTYPE html>

<html>

<body>

<h2>Card Content</h2>

<p>Add containers inside the card to create different sections:</p>

<h1>Header</h1>

</header>

name_

</div>

<h5>Footer</h5>

</footer>

</div>

</body>

</html>

"

dm-p · ‎08-15-2023

Hi @Janewhite,

To include a variable, you terminate the HTML with a double-quote where you want to add it. You then use an ampersand and the variable name, followed by a trailing ampersand and a double quote to resume the HTML, e.g.:

Measure 3 = 
VAR name_ = USERNAME()

return
"
<!DOCTYPE html>
<html>
<title>W3.CSS</title>
<meta name=""viewport"" content=""width=device-width, initial-scale=1"">
<link rel=""stylesheet"" href=""https://www.w3schools.com/w3css/4/w3.css"">
<body>

<div class=""w3-container"">
  <h2>Card Content</h2>
  <p>Add containers inside the card to create different sections:</p>
 
  <div class=""w3-card-4"" style=""width:50%;"">
    <header class=""w3-container w3-blue"">
      <h1>Header</h1>
    </header>

    <div class=""w3-container"">
      " & name_ & "
    </div>

    <footer class=""w3-container w3-blue"">
      <h5>Footer</h5>
    </footer>
  </div>
</div>

</body>
</html>
"

This is known as concatenation in DAX. Here's some further reading on how you can approach it.

Regards,

Daniel

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

My course: Introduction to Developing Power BI Visuals

On how to ask a technical question, if you really want an answer (courtesy of SQLBI)

View solution in original post

dm-p · ‎08-15-2023

Hi @Janewhite,

To include a variable, you terminate the HTML with a double-quote where you want to add it. You then use an ampersand and the variable name, followed by a trailing ampersand and a double quote to resume the HTML, e.g.:

Measure 3 = 
VAR name_ = USERNAME()

return
"
<!DOCTYPE html>
<html>
<title>W3.CSS</title>
<meta name=""viewport"" content=""width=device-width, initial-scale=1"">
<link rel=""stylesheet"" href=""https://www.w3schools.com/w3css/4/w3.css"">
<body>

<div class=""w3-container"">
  <h2>Card Content</h2>
  <p>Add containers inside the card to create different sections:</p>
 
  <div class=""w3-card-4"" style=""width:50%;"">
    <header class=""w3-container w3-blue"">
      <h1>Header</h1>
    </header>

    <div class=""w3-container"">
      " & name_ & "
    </div>

    <footer class=""w3-container w3-blue"">
      <h5>Footer</h5>
    </footer>
  </div>
</div>

</body>
</html>
"

This is known as concatenation in DAX. Here's some further reading on how you can approach it.

Regards,

Daniel

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

My course: Introduction to Developing Power BI Visuals

On how to ask a technical question, if you really want an answer (courtesy of SQLBI)

HTML

Helpful resources

Power BI Monthly Update - November 2023

Fabric Community News unified experience

The largest Power BI and Fabric virtual conference