Make This Relationship Active
By following steps for making the relationship active are-
1. Open Power BI Desktop: Launch Power BI Desktop and open your Power BI project.
2. Navigate to “Relationships” View: Go to the “Model” view by clicking on the “Model” icon on the left side of the screen.
3. Identify the Relationship: Locate the relationship you want to activate between two tables.
4. Edit Relationship: Right-click on the relationship line and choose “Edit Relationship” from the context menu.
5. Configure Relationship Options: In the “Edit Relationship” dialog, ensure that the “Active” option is checked.
Conclusion
Overall, in power bi while creating a relationships and data model between tables, you can easily understand the reports and visuals. And also you can work with data if they are in a single table.
In the whole summary, you have learnt how to create relationships between tables by using autodetect and manually methods, while working in manually methods you can use cardinality and cross-filter direction, how many types of cardinality and cross-filter are, how to use all the types of cardinality and cross-filter is uses in power bi while making relationships between tables.
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.