I couldn't allow this update to be overlooked, amidst the plethora of user questions to this topic. This release is 2 years in the making.
You can now filter your dataset using user input elements such as dropdowns. - https://support.wix.com/en/article/filtering-content-based-on-the-user-selection. I could cry, but I haven't yet tested it to see if it works as advertised. If it does, this will answer 10% of the questions in the forum!