Forum Discussion

rstrickley0308's avatar
rstrickley0308
New Member
2 years ago
Solved

Dynamic HTML Table Based on Slicer Selection in Power BI

Hello Power BI Community,

 

I'm facing a challenge in Power BI that I hope to get some assistance with. My goal is to create a dynamic HTML table that updates based on the user's selection from a slicer. The table needs to display various details of a selected program, such as Division, Line of Business, Industry, etc., and change its displayed content in real-time when a different program is selected.

 

Here is the DAX measure I've been working with to create the dynamic HTML content:

 

Dynamic HTML Content = 
VAR SelectedProgram = SELECTEDVALUE('Program Names'[Program], "No program selected")
RETURN 
    "<div style='font-family: Arial; font-size: 14px; color: #333;'>" & 
    "Selected Program: <strong>" & SelectedProgram & "</strong>" & 
    "</div>"

This measure is supposed to create an HTML visual that updates to show the currently selected program. However, I have not found a way to render this HTML content dynamically within Power BI, as there seems to be no tool or feature in the Power BI marketplace that supports such functionality. When selecting a program name from the slicer I've created I get the following display:

 

 

This is true no matter which program I select.

 

I've looked into alternatives, such as Python scripting, but this does not provide the aesthetic advatages that HTML does.

 

I am reaching out to see if anyone has encountered and overcome a similar issue or if there are custom visuals available that can achieve this. I am also open to any suggestions for workarounds that could allow for dynamically updating HTML content based on slicer selections. Atlernatively, if there are means of reproducting my table using another marketplace extension, that would also be a suitable outcome.

 

Any advice or guidance would be greatly appreciated. Thank you for taking the time to help.

 

Best regards,

 

Rob

Need Help
  • rstrickley0308's avatar
    rstrickley0308
    2 years ago

    After extensive troubleshooting and community advice, I've pinpointed the root cause of the HTML rendering issues I encountered in Power BI. Initially, my approach involved manually creating a data table via the "Enter Data" option, followed by inserting placeholder data. Subsequently, I aimed to integrate dynamic HTML content by adding a DAX formula within a new calculated column in the Column Tools section.

    However, this method led to challenges, particularly with HTML content not updating dynamically in response to filters. The crucial insight came from understanding the distinction between calculated columns and measures in Power BI. Unlike calculated columns, which are static and computed during data refresh, measures are dynamic and recalculated based on the current context, including any applied filters.

    The breakthrough fix involved shifting from using calculated columns to employing measures for embedding HTML content. This adjustment allowed the HTML content to become responsive and update dynamically in accordance with the applied filters, thereby solving the rendering issues I was facing.

    This experience underscores the importance of selecting the appropriate Power BI feature (measures over calculated columns) for specific tasks, especially when aiming to incorporate dynamic elements like HTML content.

4 Replies