Combing graphs from 2 datasets on the same tab

So I am sure what I am trying to do has been done before. I am half way there and feel like I am just missing a small piece. I am graphing revenue and hours on the same tab but the data is coming from different datasets. My filters for the date are working because they both are using the calendar date parameters on their respective other tabs for CY and PY calculations. However, I also have filters for Company, region and yard. For those they are using the fields from their own datasets on their own tabs, but I do have a hierarchy table. When I join each of the respective tables company code to the company code in the hierarchy only one them is a solid line, and the other is a dotted line. When I go back to the tab, only the data set with the solid line adjusts with the company filter. What am I doing wrong? One of the reasons I am not using the hierarchy for filters on the tabs is that sometimes yards move regions and company's and then historically they in two locations and I end up with errors.