Forum Discussion
Filtering data based on another table
madashelliam You need to ensure there is active relationship between table A and B via power bi relationship view and filtering will work automatically for you. When you create relationship in power bi ensure cross-filter direction is set to Both and this will filter both table based on selection of another. Just like shown below,
Community Championmadashelliam You need to ensure there is active relationship between table A and B via power bi relationship view and filtering will work automatically for you. When you create relationship in power bi ensure cross-filter direction is set to Both and this will filter both table based on selection of another. Just like shown below,
Hi, I am doing something similar with a similar problem-
So I want to create a filter based on the data in the table I am linking to. That second table contains a bunch of other options but I just want to have options to filter by what is in the first table.
Example:
Table 1: EE ID's (count = 5)
Table 2: EE Demo Information (count = 1000)
I want to throw a slicer on the visualization so I can filter those 5 EE' ID's by their state for example. But when I do the state slicer I have all 50 options instead of their 5 states. Is there anyway around this?