The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi, I am trying to Create an HTML Table using a measure as my values input for the HTML Content Visual.
The problem I am encountering is that I see my column headers repeating for every row I have when I add a measure for the granularity of the data.
Most Solutions online are quite outdated and tell me to input the Header with column names within the Formatting sections in the Visualizations Pane, however this is not available within the HTML Content Visual anymore.
Has anyone else come across this issue and found a work around so that the column headers are not repeated for every row?
Thanks in advance!
Solved! Go to Solution.
HTML Test 2 =
VAR Sales = summarize(Financials,Financials[Country],"sales","<tr><td><b>" & FORMAT([$ Sales], "$#,##0") & "</b></td></tr>")
RETURN "<HTML><table><tr><th>Total Sales</th></tr>" & CONCATENATEX(Sales,[sales]) & "</table></HTML>"
see attached.
Here's a sample File demonstrating my current issue. This file uses the data provided by the HTML Content Visual sample..
Expected Output:
Total Sales |
$24,887,655 |
$23,505,341 |
$24,354,172 |
$20,029,830 |
It works!
the code does get the job done!
I guess my only concern now is in terms of performance of the Summarize function when dealing with large data sets.
Thanks for the help!
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
125 | |
106 | |
84 | |
64 | |
59 |
User | Count |
---|---|
257 | |
121 | |
117 | |
100 | |
79 |