Forum Discussion
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. The second table visualization is called orders, and displays the orders placed by the selected customer id. In my Orders table visualization, I have set the interactions with the Customer's visualization to None. I throught this would prevent any clicking in the ORders visualization from changing values in the Customer's visualization. This is not the case. How do I prevent clicks in the Order's visualization from changing the Customer's visualization?
Sincerley,
Peter
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.
1 Reply
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.