Get startedGet started for free

Bi-directional cross-filtering

Although bi-directional filtering could come at a performance cost, and is generally frowned upon in Power BI, there are specific circumstances in which it can make sense. The most common scenario involves filtering slicers to exclude any dimensional values which do not have corresponding entries in the fact table.

To improve your reporting skills, you'll create two slicers that are connected and will only show values that actually exist in the fact table, Summary Statistics for Manufacturing.

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