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.
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.
You can mark your own response as an answer, so people find it.
Regards,
F
At the end of the day, you asking me if I had a calendar table is what prompted me to check my calendar table and its relationship with my data table. Which led to me realizing I was using the wrong date column in my table.
Thanks for the nudge sir haha