Table when related to Date table filters out records that seem to have perfectly valid dates

[PhilSmith]

I have a big table, with post dates.  I have a date table.  If I throw that big table into a table visual,  I see all of the records.  As soon as I activate the relationship between post date and Date, many of those records disappear.  The post_dates looks fine to me, have valid matching entries in Date, and and both are Date type fields.

Here is the link to a simple cut of the database.  Turn the Date relationship on and off, watch the records disappear and and return.

Can someone tell me what is going on here?

BrandDataDEVFORUM.pbix

Thanx

Phil

[Deku · Accepted solution]

your post dates are datetime, you set them to date in Power BI, but that just masked them. You need to set the type to date in powerquery to strip off the time

[Arash_Bhz]

Hi, you probably have a filter on your date table. Look at the visual, page, and report level filters and make sure there is no filter. Or your date table is not complete, it should have all calendar dates.

[Deku · Accepted solution]

your post dates are datetime, you set them to date in Power BI, but that just masked them. You need to set the type to date in powerquery to strip off the time

[PhilSmith · Accepted solution]

Hey Deku,

That was it.  Thank you very much!

Phil