Forum Discussion

shishanki's avatar
shishanki
Regular Visitor
3 years ago

Date silver and 24 hours data

I want to load power bi report with last 24 hours data. I am able to achieve that using measure but is it possible to also have date slicer for report so when report loads first time, user can view 24 hours data but later they can select date range also?

Any suggestions?

Need Help

4 Replies

    • shishanki's avatar
      shishanki
      Regular Visitor
      3 years ago

      Also is it possible to write isfilter for date slicer?

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi shishanki,

        Dax function not able to directly use on slicer, current you can only write a measure formula with custom expression and use on 'visual level filter' of specific visuals to apply custom filter effects.
        Here is the measure formula with condition to check if any selection applies on your slicer or they will return last 24 hour records:

        flag =
VAR currDate =
    MAX ( 'Table'[Datetime] )
RETURN
    IF (
        ISFILTERED ( 'Table'[hour] ),
        "Y",
        IF ( AND ( currDate >= NOW () - 1, currDate <= NOW () ), "Y", "N" )
    )

        Last 24 hour recordsselected on slicer

        Regards,

        Xiaoxin Sheng

  • shishanki's avatar
    shishanki
    Regular Visitor
    3 years ago

    Thank you so much. would it be possible to give 1 example, as I am new to DAX function?