Instead of using the color legend from the worksheet that is going to be filtered, show the color legend from one of the other worksheets (one that won't be filtered).
Hope this helps!
Well, nothing is being filtered, but it just so happens that all of the silos on the sheet that the color key is coming from happen to be in the green. So if I change the legend to the other sheet, the same situation could happen. I guess one solution might be to create dummy values that contain the data for all the different possible colors, but won't show up noticeably on the map. I don't know if I want to do that though because some parameters have quite a few possible values.
I'd love to be able to do this without a workaround also. I hate to clunk up a dashboard with extra stuff unless absolutely necessary.