Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Slicer with last 12 complete months and dynamic default to the latest complete month

Hello Power BI Gurus,


I'm looking for a simple solution to have a 12 month slicer that dynamically defaults to the latest complete month. For example, while we are in Apr 2023, I wanted to have a slicer with the last 12 complete months: Mar 2023, Feb 2023, ..., Apr 2022 and it defaults to the latest complete month - Mar 2023 in this example. I've come across a few posts that suggest how to make the latest month/current month/today as default but can't figure out how to have a list of months on top of it. 

Note: I have a calendar table in my report. 

See a screenshot of a similar slicer that I built in another BI platform. 



Thank heaps in advance for any suggestsions. 



Super User
Super User

Hi @Sambath ,


Your second  requirement is currently not supported. I've read somewhere in the internet that this may be a thing soon but I can't find that in the current Power BI roadmap. Alternatively, you can add a calculated column that indicates whether period is the latest one.


For your first requirement, you have to create a calculted column to filter the available periods to show only the last 12 ones.  Here's a sample formula

Number of Months from Current = 
VAR __months =
    DATEDIFF ( Dates[Date], MAX ( Dates[Date] ), MONTH ) + 1
    __months <= 12


Please  see attached pbix for your reference.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Connect to me on LinkedIn || Need consulting? Hire me for a Power BI gig on UpWork.
Learn with me on YouTube @PowerBITambayan.
Resolver I
Resolver I

Hi Sambath,

You probably want to apply a relative date filter to your slicer using the date field from your calendar. This wil show al list of the last twelve completed months. Is far as I'm aware you cannot set a dynamic default, but with sort you can set the latest month to show up on top.



Hope this helps!

Frequent Visitor

Thank for the prompt response but I wanted these two features: default to the latest complete month and a list of the last 12 months for users to select. 

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors