Time Durations in a Visual/Column Chart

[michael_knight]

Hi,

I want to be able to display time durations hh:mm:ss in a visual like a bar chart. 

The reason for this is we track our sales team on call times and we want to be able to track it month on month, year on year, day on day etc, and I feel like the best way to do that would be to use a bar chart. Currently the only way to show the data is in a Card and I feel they're fairly limited in their capabilities.

I have created a measure that shows the average and that's what I want, no problems there. I am just having problems displaying that data

I'll include a PBIX file with some test data. 

https://www.dropbox.com/s/4pbc79tpo9yg59a/help.pbix?dl=0

Any help appreicated

Thanks,

Mike

[DAST]

This formula does not work for the purposes of displaying durations in a chart. It converts minutes into hundreds and hours into ten-thousands for the purposes of displaying a whole number in 00:00:00 format, but there are not 100 seconds in a minute or 100 minutes in an hour, so the representation of relative durations on a chart will be incorrect - shorter durations will appear too small and longer ones too big.

[Greg_Deckler · Accepted solution]

https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/td-p/793639

[michael_knight]

Cheers @Greg_Deckler 

That looks good! Just so I'm right, does that mean I need to break up my current column from hh:mm:ss into seconds and then build it back up into hh:mm:ss? 

If so, how would I go about breaking it down?

[v-xuding-msft]

Hi @michael_knight ,

Do you mean like this? If so, you could try to change the type of X asix to Categorical.

Please see the attachment for more details.

[michael_knight]

Hi @v-xuding-msft ,

No, I don't mean like that. 

I mean like on the X axis it's dates like Monday, Tuesday Wednesday etc, or January Febraury March etc, and then the Y Axis the call times from that period of time 

Cheers