Context: we have one database containing data from multiple users for multiple projects. We need to share dashboards with users. The data is confidential, and users should be able to filter on 'their' projects in the dashboards.
Problem: if I add a project filter, and a user edits the value, the user can see the names of the projects of other users - although that is confidential.
Need: I'm looking for a way to share the dashboards with the users so that the filter values are restricted only to their projects. Am I missing something with the linked filter feature or any other feature, is this just not possible, or is this something only available for enterprise members?
What I already know: I am aware of ...
- Linking & limiting filter values (e.g. project) based on 'parent' filter values (e.g. user) - however, I can't properly hide the 'parent' filter (e.g. user) which is required in this case
- Hiding filter by adjusting the URL (e.g. ?user=7#hide_parameters=user) - however, the receiver can readily edit the URL again
- Clicking on graphs allows to adjust filter values which impact other graphs - however, I can't properly hide the 'parent' filter
- The fact that filter linking was initially included in this issue https://github.com/metabase/metabase/issues/5540