Forum Discussion

NyoGoat's avatar
NyoGoat
Frequent Visitor
2 years ago
Solved

One visual - 3 tables filtering wrong

Hi!  I really appreciate what I get from reading this forum.   I'm fairly new to this.  My problem:  I have 3 tables (Inventory, Cost, Comments).  I've set up relationships on unique ID's and i've ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    Create a single column table of all unique id (Table named UID).  Create relationships (Many to One and Single) from the ID column of each table to the UID table.  To your visuals/filters/slicers, drag ID from the UID table. 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Create a single column table of all unique id (Table named UID).  Create relationships (Many to One and Single) from the ID column of each table to the UID table.  To your visuals/filters/slicers, drag ID from the UID table.