2 charts from 2 sources not connecting

[jcastr02]

I have two data sources - 1.  30 Day New Hire Survey   2. 30 Day - Roles-Responsibilities (this one is just a copy with unpivoted columns)      I have looked at relationship and tied based on "start time"     The onboarding experience card visual does not change when I click on the different roles in the roles/responsibilities chart.   See below I''m also showing the data, charts on visual and hierachy.   The question "who explained your role-responsibilities?" was broke out to seperate columns and then unpivoted.  

[sturlaws]

hi @jcastr02,

you have a 1-to-many-relationship with cross filter direction set to Single between '30. Day New Hire Survey' and '30 Day - Roles-Responsibilities'. Which means that any filter you apply directly to the '30 Day - Roles-Responsibilities'-table will not propagate to the '30. Day New Hire Survey'. If your model only contains these to tables, you can change the Cross filter direction from Single to Both.

It's a bit hard to see, but it also seems like the relationship is set to Inactive. If you have other tables in your model as well, and it is neccessary to keep the relationship inactive, you will have to make measures to make use of the relatioship.

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

[jcastr02]

I may not be doing this correctly, but I have 1 main table - '30 Day New Hire Survey'    from that table I have created copies (30 Day attribute, 30 day - Find Help, 30 Day Roles-Responsibilities, and 30 Day- Training Type.   All the copied tables were used to unpivot columns and the same or unique value across all tables is the start time column.    Here is a picture of the relationships.  @sturlaws 

[sturlaws]

@jcastr02,

the text in your screen shot is quite small, so I can't really make out the details, but I see a lot of many-to-many-relationships with cross filter direction set to "Both". Which usually is not a good thing in a model.

My guess is that you need to create some dimension-tables, but you might need to create a linked table if you want cross filter the table on more than 1 dimension. 

I can't be more specific without knowing your data and datamodel. If you can share you report, or create a relevant mockup report, I'll be happy to take a look at it and suggest how to improve it. Don't share sensitive or confidential data.

[jcastr02]

Hello, @sturlaws  please try this link

If it doesn't work, please provide email and I can send file.  Thanks.  

https://app.powerbi.com/groups/me/reports/f610e5af-b8a9-483e-bc05-0ded23ca5e9a?ctid=92cb778e-8ba7-4f...

[sturlaws]

you need to upload your .pbix-file to onedrive/dropbox/other and share the link

[jcastr02]

@sturlaws 

Hello, this link should work :  

https://1drv.ms/u/s!Ava_12t7CNJtkBdZ6Omw6-8HeXki

[sturlaws · Accepted solution]

It seems like you are using the start time as unique identifier for each respondent, which will work as long as there is not to reponses starting at exactly the same time. Unlikely, but it may happen. Perhaps create an index for each response and use that instead.

When you pivot the tables, the same value is repeated multiple times, thus creating the many-to-many relationships between your tables.

I can't see how your excel file looks like, so a bit limited on what advice I can give. But, you should delete all your existing relationships. And create a table, with one column, containing all distinct start times(or indexes, if you have created that). This needs to be done in Power Query or in your source. Now connect all your 30 Day-tables to the start time-table. It should be possible to have these relationships with cross filter direction set to Both.

-s

[jcastr02]

@sturlaws   Thank you so much !!! I appreciate your feedback, that worked!