Forum Discussion
Helper IVisual 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.
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.
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.
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.
1 Reply
Oliver_BuchananOkay 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.