Using time data type as a value in bar chart

[whitej]

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

[amitchandak]

@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]

Also I need to be able to use the new column as a value and not on an axis

[whitej]

I am getting this error when creating the new column

[Greg_Deckler]

@whitej See Chelsie Eiden's Duration, I created it for this exact scenario: Chelsie Eiden's Duration - Microsoft Power BI Community

[whitej]

Do I need to create a new column or measure for this to work?

Thank you

[v-janeyg-msft]

Hi, @whitej 

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.

Best Regards,

Community Support Team _ Janey

[whitej]

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:

01-Jul-21 01:26

02-Jul-21 00:10

[whitej]

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?

[mahoneypat]

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.

(15) Austin Power BI User Group - Charticulator 101 - YouTube

Pat