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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
650AA
Helper I
Helper I

Date Table relationship Issues

Hi all looking some advice and guidance, I have set up a date table , marked it as a date table, and created an active relationship with my facts table however when I am using the date from the date table and the measures from the facts table, the data is not showing on the dates it is just showing in a blank column.

 

See below

650AA_0-1705100857611.png

 How would I fix this, any help is appeciated.

 

TIA

 

1 REPLY 1
gmsamborn
Super User
Super User

Hi  @650AA 

 

It looks like a problem with the relationship since the column has a blank date.

 

Both of the date columns in the realtionship should be date, not datetime.  If your fact table date column is datetime, you'll have to duplicate that column (in Power Query) and change the datatype of the new column to date for use in the relationship.

 

 



Proud to be a Super User!

daxformatter.com makes life EASIER!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors