Filter Connections Displayed in Tables or Lists

I would love to have an option to filter the connected records displayed in a table or list (including map lists).

For example, I have a table to display all property records, with a column that displays connected business tenant records, which have a "status" field to mark them as current or prior tenants. I would love to filter the connected business tenants displayed in that column to show only current tenants, while still maintaining the prior business tenants' connection to the property record so that I am able to include a review of the property's occupancy history in a different view.