cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
CheenuSing Super Contributor
Super Contributor

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.
Tahreem24 New Contributor
New Contributor

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.

CheenuSing Super Contributor
Super Contributor

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
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)