Filtering time for each day

[imontoya14]

Hi there, I'm not sure how easy this is but I've been stumped on this for a while. How can I pull the time to only show 6AM to 7PM everyday? instead of it showing 3AM and 9AM. I would like to remove all the data overnight and only have the report show 6AM to 7PM each day. 

Any help is appreciated. Thank you. 

[lbendlin · Accepted solution]

create a calculated column  HOUR(timestamp)  and then use that column to filter your visual.

[v-xulin-mstf · Accepted solution]

Hi @imontoya14

You can also try to create measure as:

Measure = 
CALCULATE(
    MAX(Table[Megawatts],
    FILTER(
        Table,
        HOUR([Time])>6 && HOUR([Time])<19 && HOUR([Time])<>7
)
)

Best Regards,

Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly. 

[lbendlin · Accepted solution]

create a calculated column  HOUR(timestamp)  and then use that column to filter your visual.