Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
What does a discontinuous line in the model represent? 3rd line in the below image.
Regards
Solved! Go to 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
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
@Anonymous , 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
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |