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.
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.
Solved! Go to 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
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?
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.
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
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 |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |