Matrix - expand last row (dynamic) only by default

Hi all,

I was wondering if it was possible to achieve dynamic expansion of certain rows - I've got a Matrix visual with data something like this:

i.e., the 1st column ([Relevant date]) is a date column that changes based on user selection of slicers & data refreshes, then there is a calculation group with 2 items - one [Closing value] calculates value (a measure), the other [Moevement] calculates movement for the period (i.e., how much the measure has changed from previous) and values are 2 measures ([Amount in Local tot] & [Item count]).

The columns are split by [Compliance status]. The dates (first column) also can be expanded for more detailed split.

And my ask is - is it possible to set up a PBI report so that whenever the report is refreshed or a user changes (slicer) selection, hence updating the matrix, that the LAST date in [Relevant date] is expanded to the next level but all other dates (rows) are collapsed - so that it would look something like this:

But when the refresh (or slicer selection) happens and September 8th row gets added, then the 1st September rows collapes but the last (Sep 8th) expands automatically.

If user selects slicers but the row-expansion stays as is - that's not a show-stopper - what matters most is that the last (max visible date) row is expanded by default and others are collapesed whenever data refresh happens. That's so that I could create a subscription where a report gets sent out with all dates but only last is expanded.

Is that possible?