cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
niklas3000 Regular Visitor
Regular Visitor

Set last avialable month with data as default in slicer

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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Set last avialable month with data as default in slicer

@niklas3000,

 

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#M1049...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Set last avialable month with data as default in slicer

@niklas3000,

 

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#M1049...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.