Back in SharePoint On Premise it was possible by programming to connect two webpart that will refresh depending on the other one.
What is it ?
The feature is out of the box since July 2020 for SharePoint Online. It allows to build a more user friendly page than showing plain list. You can dynamically show data based on an other list
It can filter with Title column, lookup column, managed metadata column.
You can also use it for a file viewing experience
The column must be displayed inside the view to function