What types of cross filter directions are available in Power BI table relationships?

In Power BI, relationships between tables can have two types of cross-filter directions: "Single" and "Both."

The "Single" direction allows filtering to flow in only one direction, typically from the one side (dimension table) to the many side (fact table). This means that when you filter a field in the dimension table, it will filter the related data in the fact table, but not the other way around.

The "Both" direction enables filtering to flow in both directions, meaning that filters applied on either the dimension or the fact table will influence the data in both tables. This is particularly useful when you have complex data models where you need to see how changes in one table affect another.

Understanding these cross-filter directions is crucial for accurately designing data models in Power BI and ensuring that the visualizations reflect the intended data relationships and interactions. The options suggesting “Double”, “None and All”, as well as “One-way and Two-way” do not correctly define the terms and functionality used in Power BI relationships.