Bi-directional relationships
In most situations, using single direction cross filtering on your relationships is enough. There are, however, some cases where bi-directional filters are necessary. One example is showing only relevant slicer options to end users.
Consider the following data model. The model diagram has been modified to reveal the table rows.
What would the Color slicer display when "Female" is selected in the Customer slicer?
This exercise is part of the course
Intermediate Data Modeling in Power BI
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise