Hour Filter to Capture Time up till Selected Hour

Hi jdeharo ,

Thanks for the reply from newellaa , please allow me to provide another insight:

Based on your description, I created these data.

1. create a table, put in the 24 hours of the day, and don't have a relationship with the original table.

2. create MEASURE.

MEASURE = 
IF (
    SELECTEDVALUE ( 'Table 2'[hour] ) = BLANK ()
        || HOUR ( MAX ( 'Table'[Value] ) ) <= SELECTEDVALUE ( 'Table 2'[hour] ),
    1
)

3. Use the table with hour as slicer and filter the data with MEASURE value of 1 in the filters of the original table.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

Under the Hour Slicer formatting there is an option to filter less than or equal to. In my version I appear to lose the ability to select from a list of hours. I must enter manually.

It looks like slicer that you are referencing is for a date/time field. Use a slicer that references the hour only. Your first post seems like it just displays the hour in the slicer not the full date.