Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

New User - Table visualizations/interaction with other visuals

Hello,      I am a new user running the August 2019 version of the desktop PowerBI. I have two table visualizations. the first is called Customers and displays the customer name and customer id. Th...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi Anonymous ,

     

    Based on your description, two tables should establish a "1 - *" relationship through the customer [ID. ("customer" table as 1, and "order" table as *). If "cross filter direction" is "single", when interacting with "order" table, it will not affect "customer" table. If "cross filter direction" is "both", you need to close the interaction on the visualization that you do not want to be affected （“Format”→"Edit interaction"）

    Best Regards,

    Liang 

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

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Based on your description, two tables should establish a "1 - *" relationship through the customer [ID. ("customer" table as 1, and "order" table as *). If "cross filter direction" is "single", when interacting with "order" table, it will not affect "customer" table. If "cross filter direction" is "both", you need to close the interaction on the visualization that you do not want to be affected （“Format”→"Edit interaction"）

Best Regards,

Liang 

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