I am trying to do the following:
slicer filtered by user to search for an application ID #. This will pull up one row with a few basic columns. I then want another visualization to reference the value in another column from the filtered set (not the column originally filtered) and filter the second visualization based on that resulting value.
some limitations are that these are both going to be IDs so they are long numeric values. The first filter based on application number will always be a unique value. The second ID (let's call it street name as an example) has several thousand unique values but multiple applications will have the same street name ID. I want the second visualization to show me all application within the street.
User input filter: 12345
Table:
Application - 12345
Size - 50
Customer - John Doe
Street ID - 01987654
Street Type - 2
Table 2:
Street ID - 01987654 , Application - 12345, Size - 50, etc.
Street ID - 01987654, Application - 71639, Size - 24, etc.
Street ID - 01987654, Application - 27421, Size - 98, etc.
Street ID - 01987654, Application - 85379, Size - 63, etc.
ideally I would like this to be automatic rather than the user needing to filter each individually
