Find my approach as reference below and stored in attached workbook version 9.3
selector: contains([User ShopId],str([User Template]))
User template (parameter) is filled with separate fil
filled parameter.twbx 8.5 KB
Thank you for your reply - although your suggestion doesn't work directly for me (I need to put a User Filter on the data source, not the workbook), it did get me thinking. I left-joined the complete table of locations to my source data and created the User Filter on the joined value. Initial testing looks like this method will work.
Your are welcome.
It's all about reflection;)
Have a nice one.