How to create a time range filter in Power BI report? (Part 2)

OK, here should be a full solution for fact table:

Columns:

Hour = HOUR([Hours])

Minute = IF(MINUTE([Hours])<30,0,30)

Key = CONCATENATE(CONCATENATE([Hour],":"),[Minute])

Recreate that same key in your Hours table and relate them to one another.

dbadmin - OK, I finally had time to sit down with this and model it out. Here is what I did:

I have two Enter Data queries like this:

Shift

Hour

Shift table custom columns:

Hour = HOUR([Shift])

Minute = IF(MINUTE([Shift])<30,0,30)

Key = CONCATENATE(CONCATENATE([Hour],":"),[Minute])

Hours table custom columns:

Hour = HOUR([Hours])

Minute = IF(MINUTE([Hours])<30,0,30)

Key = CONCATENATE(CONCATENATE([Hour],":"),[Minute])

I could then create a measure like this in Shifts:

CountofHours = CALCULATE(COUNT(Hours[Hour]),RELATEDTABLE(Hours))

I could then create a visualization like: