In this Power Bi article, we will see everything about Power Bi cross filter direction and how to cross-filter directions between two tables in Power Bi.
Power BI cross filter direction
- Every Power Bi Model relationship is called a cross-filter direction. Cross-filter choices are dependent on the cardinality type.
- A single cross-filter direction indicates a single direction, and Both cross-filter directions indicate both directions. Both directions will also be called bi-directional.
| Cardinality type | Cross filter Options |
| One-to-many (or Many-to-one) | Single Both |
| One-to-one | Both |
| Many-to-many | Single (Table1 to Table2) Single (Table2 to Table1) Both |
How to cross filter directions between two tables
Let us see how to make a cross filters directions between two tables in the Power BI model section,
In this example, we will choose the many-to-one cardinality relationship and single cross-filter direction for the two different tables.
In this example, we are going to use the Team Appearances Table consists of two tables called Team A and Team B as below:
Team A
Team B
- Open the Power Bi desktop and use the get data option presented under the home tab to load the data into it.
- Once the data has been loaded, choose the model section as highlighted below:
- Under the Home, tab click on the Manage relationship option as below:
A Manage relation pop-up window appears, select and click on the edit option like highlighted below:
Select the tables and columns in the edit relationship window, choose the Cardinality as Many to One relationship and the cross filter direction as Single, and click on the Ok button.
In the below screenshot, you can see that a single cross-filter direction or many-to-one cardinality relationship has been applied between two tables.
This is how to make a cross filter directions between two tables in the Power BI model section.
Here we get to know about power bi cross filter directions and how to cross filter directions between two tables in power bi.
You may like the following power bi tutorials:
- How to Merge Tables in Power BI
- How to remove Date Hierarchy in Power BI
- Power BI what if Parameter Percentage
- Power BI date slicer between a default to today
- What if Parameter in Power BI
Hey! I’m Bijay Kumar, founder of SPGuides.com and a Microsoft Business Applications MVP (Power Automate, Power Apps). I launched this site in 2020 because I truly enjoy working with SharePoint, Power Platform, and SharePoint Framework (SPFx), and wanted to share that passion through step-by-step tutorials, guides, and training videos. My mission is to help you learn these technologies so you can utilize SharePoint, enhance productivity, and potentially build business solutions along the way.
