Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowGet certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started
The short question I have is: How do I get a parent table to filter a child table, given that the records in a 'Table' visual are not selectable?
Here's what I have tried:
1- The initial attempt was to have a report with a Parent table, and have a column in it link to another report with multiple children tables. Turns out you can't do that.
2- My alternative solution was to combine the reports into one, and have the Parent table at the top, then selecting a record, to see the Child tables filtered, thus displaying the children of the selected parent record. Turns out creating this direct link was asked in this URL, and the answer was it can't be done https://community.powerbi.com/t5/Desktop/Link-two-data-grids/m-p/24899/highlight/true#M8116
3- The other option I looked into was using a Slicer, but couldn't find a way to have a more-than-one-column slicer (to simulate that Parent table at the top.
Any other ideas to achieve this?
Thanks.
What do you mean by Parent and Child tables here.
Parent -- fact??
Child -- Dimension??
Thank you for your reply. I meant something like Order - Order Details.
In your scenario, if you have built the relationship between Order table and Order Detail table. The Order Detail table supposed to be cascaded filtered when you filter on Order table. You just need to use Slicer to filter data based on your selection.
but couldn't find a way to have a more-than-one-column slicer
It's correct. We can't have multiple fields in a singer slicer. But you can apply multiple slicers, or you can use custom visuals like Hierarchy Slicer and Attribute Slicer.
Regards,
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
146 | |
72 | |
63 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |