Set last avialable month with data as default in slicer

[Anonymous]

Hi!

We need to set the last month with avialible data as default in a slicer, but also the user should be able to choose any month.

I tried the relative slicer set to month. But the user then cant choose the last month, nothing earlier.

What works is have both a relative slicer set to last, and a none-relative slicer, and change between them with booksmarks activiatad with a button. But the navigation in the report becomes a bit complex to maintain, and its not the optimal for the user to have to click a button to able to choose month.

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may take a look at the following post.

http://community.powerbi.com/t5/Desktop/Default-Behavior-Date-Filter-to-Most-Recent/m-p/235728#M104911