Forum Discussion
Discountinous line in Model
What does a discontinuous line in the model represent? 3rd line in the below image. Regards
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
Super User
Super UserAnonymous , Dotted lines inactive relation. Two table can have only one active. So others but be inactive.
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