How to build an Dashboard with an dropdown field which determines what is shown in an Chart

[KWD_ploegA]

What is the solution to get the following situation:

An Dashboard with the following 2 items:

1. An selection field with an dropdown field. The data for this dropdown field is available in Table1.
2. An chart which is showing only the results from the selected items from Table2 (Who correspond with the value in field 1).