How should you configure the relationships from Products to ProductCategory?

HOTSPOT

You are creating a Microsoft Power BI data model that has the tables shown in the following table.

The Products table is related to the ProductCategory table through the ProductCategoryID column.

You need to ensure that you can analyze sales by product category.

How should you configure the relationships from Products to ProductCategory? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

View Answer

Answer:

Explanation:

Box 1: One-to-many

Box 2: Both

For One-to-many relationships, the cross filter direction is always from the "one" side, and optionally from the "many" side (bi-directional).

Note:

Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand