Forum Discussion
Table showing blank rows when using HH:MM:SS time format issue
Believe it or not, i just found the issue and I'm smacking my head agaisnt the wall because of it lol
While i correctly created a Date column in my data table to then make the relationship to the calendar table... i used that date column from my data table instead of the date from the calendar table.
I just switched table's date field to be the one from the calendar table and the bug is gone.
While the fix was dumb, i believe that is something Power BI should be able to handle better.
Impactful IndividualHi Anonymous ,
Do you have a Calendar table?
https://www.sqlbi.com/articles/reference-date-table-in-dax-and-power-bi/
Regards,
Fernando
Hi,
Yes, i do and they are properly related by Date.
- calerof
If you provide sample data and your mesaures would be easier to try to help.
F
Believe it or not, i just found the issue and I'm smacking my head agaisnt the wall because of it lol
While i correctly created a Date column in my data table to then make the relationship to the calendar table... i used that date column from my data table instead of the date from the calendar table.
I just switched table's date field to be the one from the calendar table and the bug is gone.
While the fix was dumb, i believe that is something Power BI should be able to handle better.
- calerof
You can mark your own response as an answer, so people find it.
Regards,
F