Forum Discussion
Filter not working
Hi 888once ,
Based on the screenshots, you're supposed to filter Sheet2 by color from Sheet1 but you are filtering by Type in Sheet2 which relationship doesn't flow to Sheet1. If you want the relationship to flow to and from a table, you need to set Cross filter direction to Both. But the bigger question is why create a separate Color table if it isn't what you're going to use as a filter?
Super UserHi 888once ,
Based on the screenshots, you're supposed to filter Sheet2 by color from Sheet1 but you are filtering by Type in Sheet2 which relationship doesn't flow to Sheet1. If you want the relationship to flow to and from a table, you need to set Cross filter direction to Both. But the bigger question is why create a separate Color table if it isn't what you're going to use as a filter?
You are backwards. I am trying to filter sheet 1 by selecting a type in sheet 2.