Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
nataliesmiy1357
Helper IV
Helper IV

Custom Date Slicer

Hello!  I am wanting to create a slicer/filter of a date.  I want to create an option of

1) Past 3 months

2) Past 6 months

3) Past 12 months

4) All Data

 

How do I go about doing this?  I wanted to do a relative date filter, but I do not want to show days and weeks.

 

Thanks in advance!

2 REPLIES 2
rajendraongole1
Super User
Super User

Hi @nataliesmiy1357 -Please create a calculated column in your date table as below:

Date Range Filter =
VAR TodayDate = TODAY()
VAR Past3Months = EDATE(TodayDate, -3)
VAR Past6Months = EDATE(TodayDate, -6)
VAR Past12Months = EDATE(TodayDate, -12)
RETURN
SWITCH(
    TRUE(),
    'Date'[Date] >= Past3Months, "Past 3 Months",
    'Date'[Date] >= Past6Months, "Past 6 Months",
    'Date'[Date] >= Past12Months, "Past 12 Months",
    "All Data"
)

 

rajendraongole1_0-1725985119574.png

rajendraongole1_1-1725985210852.png

 

 

Hope this helps

 

 





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

Proud to be a Super User!





This is a great start!  But I need the Past6Months to include the Past3Months as well - how is that possible?

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.