Dynamically Filter Visualization Based On Look-Up Table

Hi Everyone,

This is my first post and I'm new to PowerBi so please excuse any lack of understanding on my part!

I have 2 data tables that I'm building my report off of, we'll call them:

1. Data_Dump_Table

2. Look_Up_Table

Table 1 contains metrics on many different products, and Table 2 contains the filters I would want to use for my visualizations depending on which product is selected. See example tables below.

The report itself would contain 2 visualization (line charts), 1 for each metric, and a dropdown box.

Table 1 Data_Dump_Table

Table 2 Look_Up_Table

The plan is:

- I select a product in the dropdown box (Example, product "A" is selected)

   - Visualization 1: Now contains all product A Metric 1 data

   - Visualization 2: Now contains all product A Metric 2 data

- Based on Table 2, I want to further filter down my two visualizations

   - Visualization 1: Should only contain Metric 1 data at "Level" 100

   - Visualization 2: Should only contain Metric 1 data at "Level" 200
And you can see that the "Level" which needs to be filtered at changes based on which Product is chosen.

So, I want to dynamically filter my visualizations based on a look up table.

Any help would be greatly appreciated, thank you!