Get startedGet started for free

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.

Data Model with a Sales fact surrounded by Product and Customer dimensions

What would the Color slicer display when "Female" is selected in the Customer slicer?

Data Model with a Sales fact surrounded by Product and Customer dimensions

This exercise is part of the course

Intermediate Data Modeling in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise