Can i control what appears in Dropdown filter

I am sure this has already been asked, but when we create a dropdown filter on a dashboard. It pulls all distinct values in the database. Is there a way to make a query to control what is in the dropdown filter? So for example if i have a dropdown of users and they all have a department. On one dashboard i want the dropdown to only show users in department A, and in another dashboard the dropdown shows users in department B.

Hi @BrettJohnson1
Currently (version 0.31.2) this is not possible. But go and vote by clicking the :+1: on the issue:

I do this by embedding the dashboard in an IFRAME and have dropdowns in the parent page. The dropdown values are passed as parameters to the dashboard.
It means you’re limited to the functionality of an embedded dashboard, but it works well.