Forum Discussion
nahla
9 years agoNew Member
Filtering a child table from a parent table
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 atte...
BhaveshPatel
9 years agoSuper User
What do you mean by Parent and Child tables here.
Parent -- fact??
Child -- Dimension??
nahla
9 years agoNew Member
Thank you for your reply. I meant something like Order - Order Details.
- v-sihou-msft9 years agoMicrosoft Employee
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,