Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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.
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.
User | Count |
---|---|
76 | |
75 | |
46 | |
31 | |
27 |
User | Count |
---|---|
99 | |
91 | |
51 | |
48 | |
47 |