Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
MaximoZambrano
New Member

Getting the value of HTML field from first row of a table to be shown in HTML viewer after filtering

This report shows a table that contains a "Body" field with HTML content. That field is shown in the HTML visual below the table.
The time and category slicers on the left side filter the table well.

MaximoZambrano_0-1725575610378.png

The problem I need to solve is just that, when using the slicers, the table refreshes BUT the HTML content does not.

It refreshes only when clicking a row in the table. I'd like to make it show the associated value of the first row of the table after the slicers filter the data.

The same problem applies when opening the report.

Is there a way to "autoselect" the first row in the table after filtering its values? 
In other words self selecting the first row of the table to make the "Body" html field show in the HTML visual.


MaximoZambrano_1-1725575830756.png

 

 

2 REPLIES 2
lbendlin
Super User
Super User

Here is the general pattern to make something the "Default value" (shown for a date column but you can adjust for your scenario)

 


- create a string representation of your date column, replace the latest date with a string "Latest"
- sort that new column by the original date column
- add a slicer or visual/page/report level filter
- set the filter to "Latest"
- publish the pbix to the workspace/app

Thank you, interesting for some other use case.
But this is not what I'm asking. The scenario is not about having a default value when landing, is about finding a way to self-select the first row of the table when we land on it or after it is filtered. 
Or having a way to set the value of the HTML viewer via a measure that gets the "Body" html field after the table is filtered.

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors