Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
PhilSmith
Helper III
Helper III

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

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

 

 

 

 

 

 

2 ACCEPTED SOLUTIONS
Deku
Super User
Super User

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

 

Deku_0-1747865502216.png

 


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

View solution in original post

Hey Deku,

 

That was it.  Thank you very much!

 

Phil

 

 

 

View solution in original post

3 REPLIES 3
Arash_Bhz
Frequent Visitor

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
Super User
Super User

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

 

Deku_0-1747865502216.png

 


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

Hey Deku,

 

That was it.  Thank you very much!

 

Phil

 

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.