Hi @ocataylo,
Without seeing the details of your data, I can’t be too specific but the following solution should work. I’m just showing one parameter in my example but you’ll have to create three - one for each of your “defining columns”. Repeat the same steps for all your parameters.
-
Create a parameter like this and set a static value which is not found in your visual.
-
Add a filter to your second visual and link it to the parameter.
-
Add a navigation action to your first visual. The target sheet should be the one which contains your two visuals.
-
Click on the +, select the parameter that you created and select the field which should be used to set its value.
-
Hide your second visual by default and add a rule to show it if the parameter value is not the static default that you chose.
When you click on a row in your first visual, the value in that row will be passed to the parameter. Since the parameter value is not the static default anymore, your second visual will be displayed. Since the parameter is also linked to the filter on your second visual, it will show the row which contains the parameter value.