Hour Filter to Capture Time up till Selected Hour

[jdeharo]

I report with a Date filter set to Today and a filter with Hour currently set to All.  I need to set it so when the Hour of 12pm is selected, the data in the report shows ALL data from start of the day up till 12pm or whatever the selected time is.   Below example, unless i go and click each hour I am only able to see the Hour selected.  With 1 Click Id like to see all Hour up till the Hour clicked.  thanks!

[v-kaiyue-msft · Accepted solution]

Hi @jdeharo ,

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

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.

[newellaa]

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.

[v-kaiyue-msft]

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.

[newellaa]

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.

[jdeharo]

@newellaa thanks this was what i was hoping for but as you see in my screenshot I dont see that option.  I have the latest Desktop version downloaded sorry what am I missing?