One to many relationship issue and not showing the data from dimension table

[Corbaz]

When using Power BI, I encountered an issue with the relationship between two tables: the Calendar dimension table and the SQL fact table. After creating a relationship between these tables using a date column as a one-to-many relationship, I utilized the date column from the Calendar table as a filter in the dashboard. However, all the data from the SQL table disappeared from the dashboard. In an attempt to troubleshoot, I created a table visual and included date columns from both tables. Surprisingly, while the date column from the SQL table displayed all available dates, the Calendar table did not show any dates at all. I'm puzzled by this discrepancy and seek guidance on how to resolve this issue.

[lbendlin]

Issues like this usually come up when one side of the relationship has dates and the other has dates and times.

[Corbaz]

Thanks for your support, I checked them, and both of them are data type, what do u think?

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Wilson_]

Hi Corbaz,

Can you please share a sample pbix file? (If you don't know how, please check the pinned thread in the forum.) It would make debugging your issue easier. 🙂