Sorting Time of Day on Chart

[knightkblack]

I have employees at the company who work as recruiters and so we track their talk time (the amount of time they are on the phone) throughout the day. I am trying to create a graph where we will be able to easily see how many minutes of talktime they had each hour during the day. For example, between 8 and 9 oclock, they had 40 minutes of talktime, 9 and 10 oclock they had 37 minutes and so on. The issue I'm running into is sorting the graph in chronological order so that the beginning of the day comes first and the end of the day comes last. Does anybody have any suggestions? I've copied a picture of the graph below.

The "hours" on the bottom are formatted as text because they have the AM/PM attached to it. I feel like that is easiest for the end user to quickly see which hours are which, but also realize that it might not be possible to sort properly with that format. 

[v-danhe-msft · Accepted solution]

Hi @knightkblack,

Based on my test, you can refer to below steps:

1.You can create a table like following one and create relationship with the original table.

2.Create a calculated column in original table with following formula.

New = RELATED(Sheet2[Order])

3.Select the Type column and make it sorted by above created column.

4.Create a Clustered column chart and add the [Hours] and [Minute] fields. And sort by the “Sort by Hours”. Now you can see the result.

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/6fnqplx7v8p2yav/Sorting%20Time%20of%20Day%20on%20Chart.pbix?dl=0

Regards,

Daniel He