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.
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.
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.
