Visualization between 3 tables

[TeodorGot]

Hi there!

I have One table with ID(unique), and two another tables with duplicated IDs, so for "General" tables I create (1:*) relationship to both direction, as you can see in screenshot. So I wan create a page with 3 slicers: One from "General" table, one from "XRT", and one from "CATO" tables. Ok -its work, when I choose one of option in some slicer another slicer change according to my choice. Now I make a R-script visualisation that include all of three slicers. And now that say is no relationship between "XRT" and "CATO" tables, and I can't activate it because I  use in different pages another connections.

Any ideas, how to solve?

Thank you

[Anonymous]

Hi  @TeodorGot ,

Try to change the relationship between the two tables and other tables to achieve a direct connection between the two tables

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

You will want to seriously rethink your data model.  Generally when you have a 1:* relationship you want the search filter to flow only from the 1 to the *.  The 1 represents the dimension table and the * represents the facts table.  Ideally you would want to end up with a star schema.  Try to avoid bidirectional searches (unless you have really good reaon) and *:* relationships.