Build custom HTML with formula

[MichaelRensing]

Howdy

I am working on a dashboard. I have a list of items, and am building drill through pages to display data about each item.  I have about 20 TRUE/FALSE columns on each item indicating wether  they are a member of that columns grouping. So for instance, Item 1 may not be a member of any of the groupings, and all of the 2 columns would be FALSE. Item 2 may be a member of 1 of them, and one of the 20 columsn would be TRUE, the other 19 would be FALSE. Item 3 may be a member of 3 of them, having 3 columns with a TRUE value, the other 17 FALSE.

I have image URLS for each of the columns. I could use a table and build out corresponsing columns with the image urls inserted by a conditional column.  The downside to this is I would need to use a table to display the images, along with the blank columns. I was thinking of a conditional column that would build HTML to display the images I could then use an HTML Visualization on the page.  This is where I am hitting a roadblock.  I can't figure out how to append content to a column. Ideally I could have a blank column, and then use condtions to append an image url if Column 1 is TRUE, Column 2 is TRUE, Column 3 is TRUE. etc.

Any ideas on how to build this out and dymaically display images for this use case?

[MichaelRensing]

@GeraldGEmerick 

I am tracking some competitions.  The competitions can be a part of one or more competition circuits. The first page lists out the competitions, and some details regarding them.  The drill through page will display a more detailed list of information.

Sample data below:

Competition	Date	Circuit 1	Circuit 2	Circuit 3	Circuit 4
Comp1	12/1/2025	FALSE	TRUE	FALSE	FALSE
Comp2	12/15/2025	TRUE	TRUE	FALSE	FALSE
Comp3	12/31/2025	FALSE	TRUE	TRUE	TRUE
Comp4	1/10/2026	FALSE	FALSE	TRUE	TRUE
Comp5	1/20/2026	TRUE	TRUE	TRUE	TRUE

Ideally I would like to have a new CircuitImages column that would be be populated will image urls from each of the applicable circuits.  So for Comp1, it would only contain the url for Circuit 2, Comp2 would have the url for Circuit 1 and Circuit 2. 

[Amar_Kumar · Accepted solution]

You cannot append content to a column dynamically. This must be done with a measure. Best approach is to build the HTML in a DAX measure and render it using an HTML visual.

Example measure:

Image_HTML =

VAR Img1 = IF (SELECTEDVALUE ( Items[Group1] ) = TRUE (),
"<img src='https://url1.png' style='height:30px;margin-right:5px;'/>","")
VAR Img2 = IF (
SELECTEDVALUE ( Items[Group2] ) = TRUE (),
"<img src='https://url2.png' style='height:30px;margin-right:5px;'/>","")
VAR Img3 = IF (
SELECTEDVALUE ( Items[Group3] ) = TRUE (),
"<img src='https://url3.png' style='height:30px;margin-right:5px;'/>", "")
RETURN Img1 & Img2 & Img3

Use this measure in an HTML Content visual on the drillthrough page.

This works because:

• Measures are evaluated per selected item

• HTML can be concatenated conditionally

• Only images for TRUE columns are shown

For a cleaner long-term model, unpivot the TRUE/FALSE columns and store image URLs in a lookup table

[MichaelRensing]

Thank you @Amar_Kumar This is what I was looking to accomplish.  I wasn't sure exactly the path to take.

[GeraldGEmerick]

@MichaelRensing I feel like you could use a measure for this but I am not sure that I completely understand what you are trying to accomplish. Any chance you could share some sample data and maybe some additional information about what you are trying to achieve?