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

Visual Not behaving as expected, relationships look correct?

Hi all,

Can't figure out why one of my visuals is showing blank date values for a certain table.

Oliver_Buchanan_0-1694741861953.png


Y-axis is just a column from one table, X-axis is from another table (my "datekey") table.

The relationship is set up between the 2 tables. The data type of both columns is set to "date", there is matching values in both tables that i have found which should be finding each other.

Oliver_Buchanan_1-1694741996302.png


I also have another table with the exact same set up which IS working, so a bit stuck as to why its not working for this problem table.

1 ACCEPTED SOLUTION

Okay wow I figured it out immediately after posting. (was playing around for an hour beforehand).

In powerquery the column in my problem table is of type "datetime" and i had only converted the type to "date" after the table loaded into the powerbi model.

Editing the powerquery to change the datatype to "date" before loading the table into the model fixed the issue.

View solution in original post

1 REPLY 1

Okay wow I figured it out immediately after posting. (was playing around for an hour beforehand).

In powerquery the column in my problem table is of type "datetime" and i had only converted the type to "date" after the table loaded into the powerbi model.

Editing the powerquery to change the datatype to "date" before loading the table into the model fixed the issue.

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.