Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Last report week as default filter

Hi there.    My report has 3 slicers, one for reporting year, reporting month and reporting week.   All come from the same exact date field.   Now, when the page loads, i'd like my report to be...
Need Help
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago

Anonymous

AFAIK, there's no such feature. You can check this idea Default Date Slicer Funtionality and vote it up.

As a workaround, you may create measures as

 

measure if no slicer selected then show the last date =
IF (
    ISFILTERED ( Table[date] ) && HASONEVALUE ( Table[date] ),
    SUM ( Table[value] ),
    CALCULATE (
        SUM ( Table[value] ),
        FILTER ( ALL ( Table ), Table[date] = MAXX ( ALL ( Table ), Table[date] ) )
    )
)
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Where does this code go in to?