Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
179 | |
108 | |
104 | |
71 | |
70 |