Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @pkoel-asb ,
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.
Hi @pkoel-asb ,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |