Multiple Table visuals interaction Filter vs Highlight

[lunako]

There are three Table visuals: 1.Order, 2.Order details with items, 3.Item production schedule, from multiple data tables.

I want:

1) when choose the order in 1, only items in that order will appear in 2. (it works now).

2) when choose one item in 2, its production schedule will appear in 3. ( half way done.)

Problems I have are:

- when 2), Table visual 2 lists all orders' items in white and the selected item in black (= highlight). I want to keep listing only the items of the selected order (= keep filter. keep the item list as it was before clicking the item.)

- when 2), Table visual 1 lists all orders in black if relationship is single or no interaction is set (back to the starting selection.). I want to keep the visual 1 as it is before clicking the item in Table visual 2.

Appreiate your input where should be checked.

[gavinma]

It doesn't work for me. Even if I press Ctrl + Click on a record on table B, table A got filtered. 

Want could have gone wrong?

[lunako]

On the report, Format tab> Edit Interactions > Choose Table B -> set None on Table A, then clicking Table B won't affect Table A filter. 

[lunako · Accepted solution]

I found the solution: when 2), a user needs to press the ctrl + click. It is hard to let my busy users know this trick... but it seems no alternative now.

https://community.powerbi.com/t5/Desktop/table-A-row-filter-on-table-B-problem/m-p/2412739#M864578