Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
104 | |
79 | |
68 | |
61 |
User | Count |
---|---|
144 | |
104 | |
103 | |
82 | |
70 |