Creating Relationships

Creating relationships between your tables allows Power BI to slice and dice your data without having to write formulas or VLookups

Depending on which version of Power BI Desktop you have installed, as well as your local settings, you might already have relationships between some of the tables.

1. Create a relationship between Date and OrderDetails by dragging the OrderDate from OrderDetails​ onto Date field in Date. Create one relationship

  1. Use the fields Date and ExpectedDeliveryDate to create a relationship between Date and OrderDetails. Note that the line is dashed, indicating an “Inactive Relationship”.​ Inactive Relationship

  2. Drag and create a relationship between CustomerID and CustomerID using the tables Customers and OrderDetails: Create Relationship

  3. Create a relationship between Cities and OrderDetails using the fields CityID and DeliveryCityID​ respectively

  4. Create a relationship between StockItems and OrderDetails on StockItemID
    It should now look like this: Final Look

  5. Double-click on the relationship line – you can then see which columns are joined and the cross filter direction.​ Show Cross Filter Selection

  6. Save your power BI report.​





End of Lab 2