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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.