Dropdown List - Query Based - 2nd Level parameter


Is there a way to have 2 dropdowns, where the query of one has a parameter that it pulls from the other one being selected. So a situation where the second dropdown is blank until you choose something in the first, and if you change the first, the second one gets updated as well?

Right now, if the query in a dropdown list has a {{Parameter}} it doesn’t seem to inherit from anything on the dashboard, even if the parameter is marked global. It only inherits from the choice in the dropdown on the query edit/view page.