Forum Discussion
Solved
Relationship without filtering
I have two datasets simular to below. I need to put into a single table visual. What I want is this... but what I get is this... I've tried a 1:* and *:* and I get the same resu...
Hi Philip_L
Ensure that the Key from Dataset 1 is the ONE and the Key from Dataset 2 is the MANY. Have a SINGLE direction relationship from Dataset 1 to Dataset 2.
Use the Dataset 1 Key in Column 1. Use Dataset 1 Name in Column 2. Use Dataset 2 in Column 3.
Also, ensure that you do not have any filters on for State being blank. Check your visual and the filter pane and make sure that State does not have any filters 🙂
Thanks for the response. Unfortunately thats how I have it setup already. I am still getting the same filtered results which is why I am not sure whats happening.