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
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 Senior Member
Senior Member

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
 
Highlighted
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 Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,083)