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.
What is the "easiest" way to enable filtering on the child record so that selecting a child record will filter the parent(s)?
In this scenario, not all parent records have children.
I have a mockup with Customer and Payment Method, I'd like to be able to click on a child Payment Method and see all the Customers (parents) who used that payment method.
I can filter parent to child of course (selecting Jane shows Cash, Credit, Debit)
But, what about selecting "Credit" so I can see everyone who used that?
I could add a count of Payment Methods to the Customer data grid, but I have to instruct it to show items with no data or it will hide all the parents without children. If I show items without data it won't filter either, it will just show counts.
*Granted, in the real world you should not have customers who have no payment method, this is just a mockup example.
Solved! Go to Solution.
If you create a measure like
ParentFilter = INT ( NOT ( ISEMPTY ( 'Customer Payment Methods' ) ) )
and put it on the visual level filter of a parent visual (or slicer) with it set to "Is 1" you should get the desired interaction.
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |