Create a relationship manually
In Power BI, users can create table relationships manually. Cardinality and cross-filter direction are automatically set during creation but users can edit them as required. By manually creating relationships in Power BI, users have greater control and are able to customize the relationships between two tables that are interconnected to each other. Steps-by-Steps guidelines are:
Step-1: Load your Data using the “Home” tab and select “Get Data”.
Step-2: On the modeling view, go to the “Manage Relationship”.
Step-3: Select “New” option.
- Select the first table and then select the column you want to use in a relationship.
- Select the second table and then select the column you want to use in a relationship.
- Then select the “OK” option.
Creating Table Relationships & Data Models in Power BI
Power BI is the most valuable tool for business/data analytics and has the power to visualize and analyze the data easily and also make informed decisions. In this article, we will cover what is data model in Power BI, relationships in Power BI, how to create relationships in Power BI using the autodetect method and manual method, and editing relationships between tables: cardinality and cross-filter direction.