Power BI Exercises

A relationship pointing the wrong way

Data Modeling · Intermediate · Chapter 5 of 10. Create and fix relationships in the Model view, and see why they matter.

The request, from Giulia Moretti, Owner, Slice & Co.: "Riverton and Lakeview show the same revenue. Someone set up the store link, but it looks broken." A bar chart of revenue by city, with the Store relationship fixed.

A relationship goes from the many side (the fact table) to the one side (the lookup table). This model has Store → Orders, the wrong way round, so a store filter cannot reach the orders.

Task: Delete the relationship from Store to Orders.

Task: Create it the right way: Orders[StoreID] to Store[StoreID].

Practice data: Slice & Co., a fictional pizza restaurant chain. The model has the Orders, Pizza, Store, Driver and Calendar tables.

How it works: the exercise opens a practice copy of the Power BI report editor in your browser. Do the task, press Check, and your result is compared with the expected answer in seconds. Hints are there if you get stuck.

Keep practicing