cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ekaponkratova Frequent Visitor
Frequent Visitor

Save latest month as a default filter

Let's say that I have a YYYY-MM filter. Is it possible to have it picked the latest month from the list of all available YYYY-MM? I've already disabled 'Allow users to save' so that I was able to save the dashboard with the latest month as of now but next week I need to manually save the new latest. So, I was wondering if there is a way to do it automatically i.e. show only the latest value in the filter.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User I
Super User I

Re: Save latest month as a default filter

Hi @ekaponkratova 

 

 

Please check the link

https://community.powerbi.com/t5/Desktop/Setting-the-Default-Value-of-a-Slicer/m-p/16442#M4550

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

View solution in original post

5 REPLIES 5
Community Support Team
Community Support Team

Re: Save latest month as a default filter

@ekaponkratova 

 

You may refer to the post below.

https://community.powerbi.com/t5/Desktop/i-have-two-dates-using-measures-and-want-to-set-these-dates...

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.
Super User II
Super User II

Re: Save latest month as a default filter

Hi @ekaponkratova ,

 

You can achieve your requirement by creating calculated column like below so it will show only latest value in your slicer. I hope I am getting right from your question. Is it something differ from my understanding so please let me know whether I caught the right track or not.

 
If I answered your question so please mark this as a Solution.
Date.PNG
 
ekaponkratova Frequent Visitor
Frequent Visitor

Re: Save latest month as a default filter

Good day Tahreem,

Thank you for the reply! I still need all months in the slider, I just want the selection to be automatically done on the latest month and have it changed automatically to the next latest month next month.

Super User I
Super User I

Re: Save latest month as a default filter

Hi @ekaponkratova 

 

 

Please check the link

https://community.powerbi.com/t5/Desktop/Setting-the-Default-Value-of-a-Slicer/m-p/16442#M4550

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

View solution in original post

ekaponkratova Frequent Visitor
Frequent Visitor

Re: Save latest month as a default filter

It seems to be it, thank you, CheenuSing! I think I even came across this posting but discarded it because on the first glance it looked different from what I needed.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors