Excel Power Pivot Relationships

0
votes

i have 2 tables as the below pic Pic 1

and i created relationship between 2 tables in power pivot as the below pic Pic 2

then i created pivot table and inserted [Project] & [Phase] in rows Area as the below pic Pic 3

the question : why the all [Phase] Column show under Each Project not only items related to each project ?

1
excelrelationshipdaxpowerpivot

1 Answers

0
votes

This is because until a measure/aggregation has been added in the Values area PivotTable do not build the relationship and the initial state is unique value combination from the two tables.

Thanks