Forum Discussion
When did/why did MS get so bad?
So, my business has spent thousands on Power BI and is still no better than using Excel. I stupidly thought it would be easy to find solutions to issues, like it was with Excel. Wrong! I've spent...
lbendlin
Super User
Super User"if I change the data type to hh:mm:ss"
Don't do that - use the FORMAT() function to get your data into the right display format, but keep your column type as is.
Nope that doesn't work either. Only certain columns will accept a format change; you didn't specify what format, but I'm guessing you meant hh:mm:ss?
When it does format to hh:mm:ss, again, when it gets to 24hrs, it resets to zero.
(and again, it won't summarise.)