Forum Discussion

jdeharo's avatar
jdeharo
Regular Visitor
2 years ago
Solved

Hour Filter to Capture Time up till Selected Hour

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 d...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.