Forum Discussion
Relationships between 3 tables, dashboards missing data
I have a data model that currently contains three tables. The "central" tables is Contacts. Contacts has a many-to-many relationship with Households, and a one-to-many relationship with Applications. Households is many to many because several contacts can live in the same household, but a contact can also be associated with several households if they have moved residences
I am trying to create a report that shows a household, the associated contacts, and the application information for those contacts. However, when I try to bring in fields from all three tables, data is missing. For example, if a contact has no records in the Applications table, they do not show up in the report at at all as soon as I add a field from the applications table. Is there a way to get around this?
Anonymous try turning on show items with no data option Show items with no data in Power BI - Power BI | Microsoft Learn
2 Replies
- parry2kSuper User
Anonymous try turning on show items with no data option Show items with no data in Power BI - Power BI | Microsoft Learn
- AnonymousNot applicable
parry2k Thank you! The missing rows are showing now - that saved me a ton of headache!