Forum Discussion
Relationship with date table not working
olivierlaloo Check to see whether or not the data type is date in the "Edit Query" section. I've run into this before and wasted a bunch of time because I didn't check there. My guess, is that it is still text in that section. (Load vs. Model, they both need to have the same datatypes for some reason).
olivierlaloo Check to see whether or not the data type is date in the "Edit Query" section. I've run into this before and wasted a bunch of time because I didn't check there. My guess, is that it is still text in that section. (Load vs. Model, they both need to have the same datatypes for some reason).
Hi Anonymous, I am facing same problem. I have created date table using DAX in Power BI desktop. As I don't have date table in my source database. I have checked other dates types like order date and invoice date they match in data type both in Power query and report window. Can you please advice me what else can be problem???
Thanks in advance!!
Anonymous Can you give an example of what the issue is specifically?
Hi Anonymous, Sorry for late replay
I am designing a weekly sales report for last four week. By stores and categories. but when I am adding week number column to X-axis , I am getting blank in the report visualization.before adding week column to X-Axisafter adding week number column to X-axis