Relationship without filtering

[Philip_L]

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 results.

What am I doing wrong? Any help would be greatly apprecaited.

[TheoC · Accepted solution]

Hi @Philip_L 

Here is what you are wanting mate. I just posted a fresh reply so that it cleans up the comments, etc.

[TheoC]

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 🙂

[Philip_L]

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.

[TheoC]

@Philip_L my apologies!  I misread your output, all you need to do is press "Show Items With No Data" on the Key / State / Name fields 🙂

[TheoC]

Hope this helps 🙂