Aan de slagGa gratis aan de slag

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

Deze oefening maakt deel uit van de cursus

Intermediate Data Modeling in Power BI

Cursus bekijken

Praktische interactieve oefening

Zet theorie om in actie met een van onze interactieve oefeningen.

Begin met trainen