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.
@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
@whitej See Chelsie Eiden's Duration, I created it for this exact scenario: Chelsie Eiden's Duration - Microsoft Power BI Community
What's your original column and what do you want to change to? Can you share some sample data? So we can help you soon.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Community Support Team _ Janey
So I have created a new measure called Duration Engineering Done to convert seconds to hh:mm:ss and it looks fine.
But I only want to see hh:mm. So if I change the Format at the top to 00:00 and remove the "seconds" in the dax then I am getting the following.
What I want to see is:
Great, thank you. Moving in the correct direction. I just had to remove the SUM from VAR Duration = SUM[Duration[
Also do not need the seconds so this is what I have done but having a slight problem when changing the fromat from 00:00:00 to 00:00. Looking at my DurationTime Column there is no : between my hour and my minute. Anything I can do to fix this?
Another way to do what you want is to keep your duration column as a decimal, create two measures (one for your total decimal, and one with that formatted as "hh:mm"), and use the Charticulator visual to make your chart. You would use the text measure in a text box label at the top of the bars.
Click here to read more about the June 2022 updates!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.