Forum Discussion

Anonymous

Not applicable

5 years ago

working with multiple table

Hi I have 3 tables: the id is the key: one to many on table 1 to table 2. I created the relationship between all the table on the id key. Each id column are suposed to be connected now howe...

Icon for Super User rank

Super User

5 years ago

Anonymous , what output you want is not clear.

But you can join ID of table 1 to ID to Table 2 and Table 3

And analyse

Anonymous
Not applicable
5 years ago
So the relationship helps to make a new quierry with join?

The output should be graphs where I can see the how parameter from table 1 influence other parameters on table 2.
I tried to do this by adding a slicer where I can choose the id in the slicer and then to see the influence of ID on each graph. The problem is that the slicer is with the id from table 1. So the filter works on graph from table 1 but on graph from table 2 or 3 the slicer with id from table 1 does not filter anything.
The only way is to make a new quierry? or to combine maybe?
- v-deddai1-msft
  Community Support
  5 years ago
  Hi Anonymous ,
  
  What's the relationship between three tables? Is it like the screenshot below?
  
  If so, the slicer on table1 will filter data in table2 and table3.
  
  If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  
  Best Regards,
  Dedmon Dai

Related content