top of page
Search

A Simple Trick to Always Display the Latest Month in Power BI (Even After Refresh)


A practical slicer pattern that automatically updates to the latest data


PBIX available for download at the end of this article! 🥳


So this is more of a micro-tip — I’ve had to use it recently so thought it could be a good idea to share the idea with others in case you run into the same situation. 🤓

In many reports, users need to:

  • View current data by default

  • But still be able to go back in time using a slicer

In those cases, the report usually contains both current and historical data, and a slicer defines which time period is being displayed.


The problem?After a dataset refresh, slicers do not automatically move to the latest period.

If the slicer was initially set to, say, March 2024, the report will still open on March 2024 after refresh — even if new data for April 2024 is now available.Unless you manually change the slicer selection and republish, users won’t see the most recent data.


Here’s a short demo with the visual from the cover image of this article:



 
 
 
bottom of page