Multiple bridged tables and relationships

[Anonymous]

I have three table visuals.  Each tables shares the same first two colums (HSECaseDimkey and Case Number).   The third column contains a field  from the bridged table as shown in the model.  If I try to add the bridged Consequecnce field to either of the lower two table visuals, the visual will break complaining about the relationships.

What should I do to allow each of the 3 bridged tables to appear in the top visual?

[selimovd]

Hey @Anonymous ,

I don't really understand from which tables you want to show which fields.

But it breaks for sure because of the filter directions. 

Why do you use the bridge tables? If possible I would change that. As a "quick solution" you could also set the outer relationships to bidirectional filtering. That should solve the issue in the short term:

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[selimovd]

Hey @Anonymous ,

I wanted to ask if you could solve it with the change of relationship or if you need further help?

I'm curious if you could solve this issue 🙂

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic