Power BI Relationship Practice: Which Tables Does the Filter Reach?
Unlimited Power BI relationship practice. Each problem draws a small model with one filter: tap every table the filter reaches, or pick what a visual shows. A wrong answer names the slip, such as going against a Single arrow.
Sales
Tap the tables in the model.Tables tapped: 0
Power BI exam prep
Preparing for PL-300 or DP-600? Start with the free real exam questions, then get the full pack.
Relationship FAQ
What does cross filter direction Single mean in Power BI?
Filters flow one way: from the one side of a one-to-many relationship to the many side. In model view the single arrowhead on the line points the way the filter flows, so a filter on Sales does not reach Product.
What does cross filter direction Both do?
The filter also flows from the many side back to the one side. In Microsoft's example, a Customer filter on Australia with Both between Product and Sales makes the Product slicer list only the product sold to Australian customers.
Does a one-to-one relationship filter both ways?
Yes, always. Microsoft's guidance says all one-to-one relationships must be bi-directional and that it isn't possible to configure them otherwise.
Do inactive relationships filter a visual?
No. A dashed line is an inactive relationship, and it only passes filters when a measure uses it with the USERELATIONSHIP DAX function. There can only be one active filter path between two tables.
Can a filter pass through more than one table?
Yes. Filters keep going as long as there is a relationship path. A filter on Category reaches Product, and from Product it reaches Sales.
What do the 1 and * on a relationship line mean?
They show the cardinality. The one side column holds unique values and the many side column can repeat them, so 1 and * is one-to-many and 1 and 1 is one-to-one.
What happens when two filters reach the same table?
They combine with AND: a row stays only when it passes every filter.
Is this on the PL-300 exam?
Yes. The PL-300 study guide lists "Define a relationship's cardinality and cross-filter direction" and "Implement role-playing dimensions" under Model the data.
What does this drill leave out?
Many-to-many relationships, limited relationships, ambiguous paths, row-level security and DAX measures. Each model has four invented tables and one active path between any two of them.
Sources
- Microsoft Learn, Model relationships in Power BI Desktop: filters propagate along a relationship path, several tables included; cardinality 1 and *; the cross filter options for each cardinality; one-to-many always filters from the one side and Both adds the many side; one-to-one always filters both ways; arrowheads show the direction, a dashed line is inactive; only one active path between two tables; two filters on a table combine with AND.
- Bi-directional relationship guidance: the Customer, Product and Sales example rows, the card of 30 for Australia and the Product slicer that lists only T-shirt with Both. The drill's tests reproduce them from the saved page.
- Active vs inactive relationship guidance: inactive relationships only propagate filters when a DAX expression uses them, as in the role-playing date example with Sales[ShipDate].
- One-to-one relationship guidance: the relationship filters in both directions, which is always the case for one-to-one relationships.
- Exam PL-300 study guide (skills measured as of April 20, 2026) and Exam DP-600 study guide: "Define a relationship's cardinality and cross-filter direction", "Implement role-playing dimensions" and "Implement a star schema for a semantic model".
- Checked 21 November 2026. The tool's own approach: the tables are invented, each model has four of them, the active relationships never give two paths between two tables, the filtered table keeps only its own filter, and every key on the many side exists on the one side. An independent re-solver agreed with the drill on 20,000 generated problems.
Checked 21 November 2026 against Microsoft Learn: Model relationships in Power BI Desktop and the Power BI relationship guidance.
- DrillSQL Server restore practicePick the full, differential and log backups to restore, in order, to a point in time or the point of failure.
- DrillTableau order of operations practiceTap filters and calculations in the order Tableau runs them, or work out what a small view shows with a context filter, FIXED, top N or table calculation.
- DrillMongoDB compound index practiceTap whether a compound index can support a filter and a sort, and pick the key order by the ESR guideline.