Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a date table, I confirmed that it is marked as the date table, but whenever I use "Month Year" or any form of the date table in my visuals in conjunction with my data tables, the visuals do not seperate by date and instead show the sum total of the entire data table spread over all dates. I verified that the date column in my data table is in proper data type, "date/time". If I do not use the date table and instead use the date column in the table I am referencing in the visual, the data comes back perfect. The issue is that I want to use "Month Year" as the axis. I know that I can create a column in the data table that will pull the Month Year the way I want to, but I really want to figure out why I cannot use the date table in conjunction with my data tables if the date table and data tables have a relationship, the relationship is active and is one to many.
Has anyone had this issue or now what the culprit is?
Solved! Go to Solution.
yes, it does matter: both fields must be the same type. If your data table contains date/time, you should create separate new columns for date and time in your data table (and then create a dimension table for time to join to the data time column). The date fields in both your date table and data table must be type date
Proud to be a Super User!
Paul on Linkedin.
the date field in your date table should be type date (not date/time). Both date fields in your date table and data table should incidentally be the same type
Proud to be a Super User!
Paul on Linkedin.
So the date column in the date field is set to "Date". Sorry, I mis wrote the original, the data table has a date/time designation. Does that make a difference? Can the date column of the date table be designated as "Date" and the data table date column be "date/time"? Time has to be in the data table time column for our needs. Below is the outcome I am getting sometimes as well. All of the data is coming back as blank instead of in the months they are supposed to be.
yes, it does matter: both fields must be the same type. If your data table contains date/time, you should create separate new columns for date and time in your data table (and then create a dimension table for time to join to the data time column). The date fields in both your date table and data table must be type date
Proud to be a Super User!
Paul on Linkedin.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |