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 filtered by the very last reporting week, nothing else.

 

If I select this in the editor, save and publish it works. But I'd like this to be automatic instead of manually selecting it in the editor.

 

Can this be done?

Need Help

3 Replies

  • 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?

      • Eric_Zhang's avatar
        Eric_Zhang
        Microsoft Employee
        9 years ago
        Anonymous wrote:

        Where does this code go in to?

        Anonymous

        It is a measure, and you put it into the visuals.