Discountinous line in Model

[Anonymous]

What does a discontinuous line in the model represent? 3rd line in the below image.

Regards

[v-lili6-msft · Accepted solution]

hi  @Anonymous 

That means this is an inactive relationship between two tables.

please refer to this document:

https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive

and for modeling in power bi, I would suggest you have a look these document:

https://docs.microsoft.com/en-us/power-bi/guidance/star-schema

Regards,

Lin

[amitchandak]

@Anonymous , Dotted lines inactive relation.  Two table can have only one active. So others but be inactive.

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

The other reason. Power bi does it to avoid loops and two paths. You can not reach Table 1 to Table 2 by two paths. By using bi-directional join you may reach to the table itself.  Power bi inactivate any such possibility

[Greg_Deckler]

@Anonymous - That is an inactive relationship. It gets created when there is more than one path between tables. You can use USERELATIONSHIP to use the inactive relationship in a measure.