Filter visual based on grouped result

[colsen12]

I have 2 tables like the below. Let's call one 'Test Table':

Location	Product	Date	Supply	Demand	Above Target	Below Target
1	100	1/1/2023	50	60	0	10
1	100	2/1/2023	60	50	10	0
2	100	3/1/2023	20	40	0	20
3	200	1/1/2023	35	50	0	15
3	200	6/1/2023	20	20	0	0
4	100	5/1/2023	10	10	0	0
4	300	1/1/2023	70	60	10	0

and the 2nd one 'Master Table':

Planner	Product
Name1	100
Name2	200
Name3	300

I'd like to create 2 slicers:

1) A slider to determine number of months in the future

2) A slider for the sum of 'Supply' grouped by Location & Product 

I want these 2 sliders to affect 2 separate visuals at the same time:

1) A chart showing sum of supply within the sliced number of months of today's date

2) A chart showing sum of 'Above Target' and 'Below Target' separately for each planner name, only for 'Product' that meet the Supply and Date ranges entered in the slicer

I am having a hard time wrapping my head around the logic of connecting the 'Supply' slider result to the 2nd visual (with the above and below target) when supply is not part of the visual.