Forum Discussion
Using time data type as a value in bar chart
I have a column showing seconds (whole numbers) and would like to convert it to hh:mm and use it in a bar chart with date on the Y axis. Is it possible in Power BI? I have managed to create a column with hh:mm but when pulled into the value field it only displays the count.
Thank you
James
9 Replies
whitej , New time column
time = time(time(Quotient([Col],3600) ,Quotient(Mod([Col],3600),60) ,mod(mod([Col],3600),60)) )
Add with date if needed
Date time = [Date] +[Time]
Use on axis
I am getting this error when creating the new column
whitej See Chelsie Eiden's Duration, I created it for this exact scenario: Chelsie Eiden's Duration - Microsoft Power BI Community
Also I need to be able to use the new column as a value and not on an axis
