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 2...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi shishanki,

You can write a measure formula with ISFILTERED function to check the current filter selections and setting default condition of last 24 hours if no item selected to use on 'visual level filter'.

ISFILTERED function (DAX) - DAX | Microsoft Learn

Regards,

Xiaoxin Sheng

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