Forum Discussion
lunako
4 years agoFrequent Visitor
Multiple Table visuals interaction Filter vs Highlight
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 ap...
- 4 years ago
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
gavinma
4 years agoNew Member
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?
- lunako4 years agoFrequent Visitor
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.