Graph the hour of the day

[AkrMus]

I have table of customers that has these data

CustomerID, DemandHour, PurchaseHour

1001              15                   19

1002              03                   07

1003              19                   07

1004              23                   19

1005              15                   19

1006              23                   16

1007              15                   10

I want to find the count of customers of each hour

I want to graph them to look like this

How Can I do that ???

Appreciate your help.

[v-shex-msft · Accepted solution]

Hi @AkrMus ,

You can create a table with 24 hours(0~24), then write two measure to check table records if records time field are same as current hour label.

PC =
CALCULATE (
    COUNT ( T0[CustomerID] ),
    FILTER ( ALLSELECTED ( T0 ), [PurchaseHour] = MAX ( 'Hour'[Value] ) )
)

DC =
CALCULATE (
    COUNT ( T0[CustomerID] ),
    FILTER ( ALLSELECTED ( T0 ), [DemandHour] = MAX ( 'Hour'[Value] ) )
)

Regards,

Xiaoxin Sheng