Power BI Desktop 中的關聯性檢視Relationship View in Power BI Desktop

[關聯性檢視] 會顯示模型中所有的資料表、資料行及關聯性。Relationship View shows all of the tables, columns, and relationships in your model. 這在模型包含許多資料表,且其關聯十分複雜時十分實用。This can be especially helpful when your model has complex relationships between many tables.

讓我們一起來看看。Let’s take a look.

A.A. 關聯性檢視圖示 - 按一下此圖示可在關聯性檢視中顯示您的模型Relationship View icon – Click to show your model in Relationship View

B.B. 關聯性 - 將游標暫留在關聯性上可顯示所使用的資料行。Relationship – You can hover your cursor over a relationship to show the columns used. 按兩下關聯性可以在 [編輯關聯性] 對話方塊中開啟該關聯性。Double-click on a relationship to open it in the Edit Relationship dialog box.

在上圖所示的 Stores 資料表中,有一個與 StoreKey 相關的 Sales 資料表,本身也具有一個 StoreKey 資料行。In the figure above, you can see the Stores table has a StoreKey column that’s related to the Sales table, which also has a StoreKey column. 這是多對一 (*:1) 的關聯性;線中間的圖示指出交叉篩選方向的設定為 兩者We see it’s a Many to One (*:1) relationship, and the icon in the middle of the line shows the Cross filter direction set to Both. 在圖示上的箭頭指出篩選內容流量的方向。The arrow on the icon shows the direction of the filter context flow.

若要深入了解關聯性,請參閱在 Power BI Desktop 中建立和管理關聯性.To learn more about relationships, see Create and manage relationships in Power BI Desktop.