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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
P0W3RB1
Helper I
Helper I

Timeline slicer - Limit Range

Hi

 

I have a timeline slicer, it goes all the way back to 2011 but im only intersted in last year and current year. Is there someway of limiting it? it uses a date field from a calendar table, i can see dates that go all the way back to 2011 but how can i exclude them?

 

Thanks

2 REPLIES 2
AlexChen
Microsoft Employee
Microsoft Employee

Hi,

 

For example, you have a table (called “myTable”) like below:

 

1.png

 

You can create a new table with data of this year and last year only :

 

newTable = FILTER(mytable, YEAR(mytable[date]) = Year(Today()) || YEAR(mytable[date]) = Year(Today()) - 1)

 

2.png

 

Now you can create a new slicer with “newTable[date]” and there is only year 2015 and year 2016.

 

3.png

 

Best Regards

Alex

 

 

 

bullius
Helper V
Helper V

Have you tried applying a page or report level filter?

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!