So I have this sample data:
On my dashboard I have 2 single select filters for Region and Country, current selection is Region=APAC, country=CHINA. But when I select the region=EMEA, the country filter is still on CHINA selection and so no chart is displayed. Is there a way to automatically have a new selection based on the available data? The task of selecting a new value is not quite obvious to a new user of the dashboard.
As far as I know there isn't a way to do this. Following this thread in case there's a workaround provided by someone.