tables not connecting from three different tables -

[jcastr02]

I have three different survey types (trainer, people leader, and 30 day survey that I'm putting on this page, each in different tables.  I have slicers created but they are not connecting, Im sure it's a relationship issue but I can't seem to figure it out.  Please see recruitment-onboarding tab.  https://1drv.ms/u/s!Ava_12t7CNJtkEcQHD-Ralk-Qgjf?e=56kx5j 

[v-easonf-msft · Accepted solution]

Hi , @jcastr02 

Take these two tables as an example.

Need to create a corresponding many-to-many relationship as below  , and the filtering effect can be generated.

Best Regards,
Community Support Team _ Eason

[Anonymous]

Can you explain your logic in the "Function Lead Survey" are of the relationships? I can't make sinse of what is going of there with the " - Start Time" table especially.

[jcastr02]

@Anonymous  yes the relationship for the start time is so that I only have 1 table with the unique values to tie to the rest of the visuals within the People Leader tab.  I used this solution to make sure that slicers worked on that tab (People Leader).

[jcastr02]

@Anonymous  to add --had to do this to be able to sort each of the visual with comments from most recent to least recent  < if i sort in my master file, all other items will unsort - so created seperate tables for each free response to be able to sort appropriately.  

[Anonymous]

Interesting... I think it has something to do with this:

What is the purpose of those 5 blank columns?

[jcastr02]

@Anonymous I saw that as well, I deleted the columns but still having same issue.