Using bidirectional cross-filtering
Data relationships are a fundamental component of Power BI, allowing you to link tables and perform complex data analysis. One feature that enhances the capabilities of relationships is bidirectional cross-filtering (BDCF). However, wielding this double-edged sword effectively is crucial, as it can lead to unexpected errors and performance bottlenecks. In this chapter, we’ll explore this in depth, learning how to harness its power without compromising data cleanliness. You can identify a join that has BDCF enabled because of the box with two arrows, as seen in the following screenshot:
Figure 12.4 – Screenshot showing a BDCF relationship in Power BI
In the next section, you will learn more about what exactly BDCF is.
What is bidirectional cross-filtering?
Bidirectional cross-filtering is a feature that enables tables in Power BI to filter each other in both directions, allowing for more complex and...