Control Chart - with time

[poogleshmoogle]

Hello, 

I need some help with this - if it is even possible. I have a column with timestamp and I want to make a control chart to show the average time as the line over the months. Then have 8am as the LCL and 8:30am as the UCL. Is this possible? The only way I could do it was by using decimals, and that's not very useful to show clients. Any help is appreciated! 

[Greg_Deckler]

@poogleshmoogle You should be able to present timestamps using Custom Format Strings. Check this out. Chelsie Eiden's Duration - Microsoft Power BI Community Otherwise, would need sample data, etc.

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[poogleshmoogle]

Date	First Case
21 September 2022	8:02 AM
21 September 2022
1 October 2022	8:13 AM
2 October 2022	8:05 AM
10 October 2022	9:20 AM
10 October 2022
13 October 2022	10:00 AM
11 October 2022	8:03 AM
12 October 2022	8:15 AM

Hi, sorry for the late reply, but here's what my table looks like (minus all the other columns) First case = the timestamp the first case of that day was performed. I want to make a control chart, where I can plot month vs average first case time for that month. The only way I am being able to do that is by using decimals - but clients won't understand decimals. Is there a way to do it?