cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jcastr02 Member
Member

tables not connecting from three different tables -

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 

6 REPLIES 6
HamiltonVT Member
Member

Re: tables not connecting from three different tables -

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 Member
Member

Re: tables not connecting from three different tables -

@HamiltonVT  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).

Highlighted
jcastr02 Member
Member

Re: tables not connecting from three different tables -

@HamiltonVT  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.  

 

HamiltonVT Member
Member

Re: tables not connecting from three different tables -

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

Annotation.png

 

What is the purpose of those 5 blank columns?

jcastr02 Member
Member

Re: tables not connecting from three different tables -

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

Microsoft v-easonf-msft
Microsoft

Re: tables not connecting from three different tables -

Hi , @jcastr02 

Take these two tables as an example.

41.png

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

42.png

51.png

 

 

Best Regards,
Community Support Team _ Eason

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors