Last report week as default filter

[Anonymous]

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?

[Eric_Zhang]

@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]

Where does this code go in to?

[Eric_Zhang]

---

@Anonymous wrote:

Where does this code go in to?

---

@Anonymous

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